Update # 1327. List the Products Ordered in a Period.sql

Qian-Yu-2020 · Qian-Yu-2020 · commit 0c303a88d3ff · 2020-11-24T01:56:41.000-05:00
diff --git a/Order and Deliver/# 1327. List the Products Ordered in a Period.sql b/Order and Deliver/# 1327. List the Products Ordered in a Period.sql
@@ -5,7 +5,7 @@
 SELECT product_name, SUM(unit) AS unit
 FROM Orders 
     JOIN Products USING(product_id)
-WHERE LEFT(order_date, 7) = "2020-02"
+WHERE order_date between "2020-02-01" AND "2020-02-29"
 GROUP BY 1
 HAVING SUM(unit) >= 100;
 
