Skip to content

Commit 651c552

Browse files
committed
Update README.md
1 parent 7a7e5b8 commit 651c552

File tree

1 file changed

+10
-0
lines changed

1 file changed

+10
-0
lines changed

README.md

+10
Original file line numberDiff line numberDiff line change
@@ -558,4 +558,14 @@ ON p.product_id = o.product_id
558558
WHERE DATE_FORMAT(order_date, '%Y-%m') = '2020-02'
559559
GROUP BY p.product_name
560560
HAVING SUM(o.unit) >= 100
561+
```
562+
563+
[1484. Group Sold Products By The Date](https://leetcode.com/problems/group-sold-products-by-the-date/)
564+
```sql
565+
SELECT sell_date,
566+
COUNT(DISTINCT product) AS num_sold,
567+
GROUP_CONCAT(DISTINCT product) AS 'products'
568+
FROM Activities
569+
GROUP BY sell_date
570+
ORDER BY sell_date
561571
```

0 commit comments

Comments
 (0)