Finished Question 5 of 3-6

Kota Uchino · Kota Uchino · commit 4857ed3b1e7d · 2018-01-24T23:36:45.000+09:00
diff --git a/3/3-6 相関副問い合わせを使う/5.sql b/3/3-6 相関副問い合わせを使う/5.sql
@@ -0,0 +1,22 @@
+SELECT
+  ProductID
+, ProductName
+FROM
+  Products AS p
+WHERE
+  ProductID IN
+  (
+    SELECT
+      ProductID
+    FROM
+      Sales AS s
+    WHERE
+      p.ProductID = s.ProductID
+    HAVING
+      AVG( Quantity ) <= MAX( Quantity ) / 10
+  )
+ORDER BY
+  ProductID
+;
+
+-- 理解できていないのでもう一度復習する
