add 1484

fishercoder1534 · fishercoder1534 · commit 75e6d34b7801 · 2020-07-22T16:51:25.000-07:00
diff --git a/README.md b/README.md
@@ -992,6 +992,7 @@ _If you like this project, please leave me a star._ &#9733;
 |-----|----------------|---------------|---------------|---------------|-------------
 |1517|[Find Users With Valid E-Mails](https://leetcode.com/problems/find-users-with-valid-e-mails/)|[Solution](../master/database/_1517.sql) || Easy |
 |1495|[Friendly Movies Streamed Last Month](https://leetcode.com/problems/friendly-movies-streamed-last-month/)|[Solution](../master/database/_1495.sql) || Easy |
+|1484|[Group Sold Products By The Date](https://leetcode.com/problems/group-sold-products-by-the-date/)|[Solution](../master/database/_1484.sql) || Easy |
 |1407|[Top Travellers](https://leetcode.com/problems/top-travellers/)|[Solution](../master/database/_1407.sql) || Easy |
 |1384|[Total Sales Amount by Year](https://leetcode.com/problems/total-sales-amount-by-year/)|[Solution](../master/database/_1384.sql) || Hard |
 |1378|[Replace Employee ID With The Unique Identifier](https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/)|[Solution](../master/database/_1378.sql) || Easy |
diff --git a/database/_1484.sql b/database/_1484.sql
@@ -0,0 +1,7 @@
+--# Write your MySQL query statement below
+select sell_date,
+    count(distinct(product)) as num_sold,
+    group_concat(distinct product order by product asc separator ',') as products
+from Activities
+group by sell_date
+order by sell_date asc;
