Finished "Let's write" of 3-5

Kota Uchino · Kota Uchino · commit fefc42940dc0 · 2018-01-13T22:46:28.000+09:00
diff --git a/3/3-5/0.sql b/3/3-5/0.sql
@@ -0,0 +1,13 @@
+SELECT
+  p1.ProductName AS 商品名1
+, p2.ProductName AS 商品名2
+, ( p1.Price + p2.Price ) AS セット価格
+FROM
+  Products AS p1
+    JOIN
+  Products AS p2
+    ON p1.ProductID < p2.ProductID
+    AND p1.CategoryID <> p2.CategoryID
+WHERE
+  ( p1.Price + p2. Price ) > 2500
+;
