Dashboard Temp Share Shortlinks Frames API

HTMLify

Day 44
Views: 3 | Author: djdj
1
2
3
4
5
6
7
8
# Write your MySQL query statement below
SELECT
    sell_date, 
    COUNT(DISTINCT product) AS num_sold, 
    GROUP_CONCAT(DISTINCT product ORDER BY product SEPARATOR ',') AS products
FROM Activities
GROUP BY sell_date
ORDER BY sell_date;