1484.sql (185B)
1 SELECT sell_date, 2 COUNT(DISTINCT product) AS num_sold, 3 GROUP_CONCAT(DISTINCT product ORDER BY product) AS products 4 FROM Activities 5 GROUP BY sell_date 6 ORDER BY sell_date