We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent 7a7e5b8 commit 651c552Copy full SHA for 651c552
README.md
@@ -558,4 +558,14 @@ ON p.product_id = o.product_id
558
WHERE DATE_FORMAT(order_date, '%Y-%m') = '2020-02'
559
GROUP BY p.product_name
560
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
571
```
0 commit comments