Finished Question 5 of 3-5

Kota Uchino · Kota Uchino · commit 27d50a44fb7c · 2018-01-18T19:52:29.000+09:00
diff --git a/3/3-5/5.sql b/3/3-5/5.sql
@@ -0,0 +1,15 @@
+SELECT
+  c1.CustomerName AS 顧客名1
+, c2.CustomerName AS 顧客名2
+FROM
+  Customers AS c1
+    JOIN
+  Customers AS c2
+    ON c1.CustomerID < c2.CustomerID
+    AND c1.PrefecturalID = c2.PrefecturalID
+    AND c1.CustomerClassID = c2.CustomerClassID
+WHERE
+  NOT c1.PrefecturalID = 13
+  -- AND
+  -- NOT c2.PrefecturalID = 13
+;
