Skip to content

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 651c552

Browse filesBrowse files
committed
Update README.md
1 parent 7a7e5b8 commit 651c552
Copy full SHA for 651c552

File tree

1 file changed

+10
-0
lines changed
Filter options

1 file changed

+10
-0
lines changed

‎README.md

Copy file name to clipboardExpand all lines: README.md
+10Lines changed: 10 additions & 0 deletions
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 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.