tcv-tclsbc
diff --git a/‎README.md
Copy file name to clipboardExpand all lines: README.md
+14Lines changed: 14 additions & 0 deletions b/‎README.md
Copy file name to clipboardExpand all lines: README.md
+14Lines changed: 14 additions & 0 deletions
@@ -544,4 +544,18 @@ CASE WHEN MOD(id,2)=0 THEN (LAG(student) OVER (ORDER BY id))
 ELSE (LEAD(student, 1, student) OVER (ORDER BY id))
 END AS 'Student'
 FROM Seat
+```
+
+[1327. List the Products Ordered in a Period](https://leetcode.com/problems/list-the-products-ordered-in-a-period/)
+```sql
+-- name, amt
+-- >= 100 units, feb 2020
+
+SELECT p.product_name, SUM(o.unit) AS unit
+FROM Products p
+LEFT JOIN Orders o
+ON p.product_id = o.product_id
+WHERE DATE_FORMAT(order_date, '%Y-%m') = '2020-02'
+GROUP BY p.product_name
+HAVING SUM(o.unit) >= 100
 ```