Skip to content

1484. Group Sold Products By The Date 👍

1
2
3
4
5
6
SELECT
  sell_date,
  COUNT(DISTINCT product) AS num_sold,
  GROUP_CONCAT(DISTINCT product ORDER BY product) AS products
FROM Activities
GROUP BY 1;