Last updated 3 years ago
Was this helpful?
SELECT sell_date, COUNT(DISTINCT product) AS num_sold, GROUP_CONCAT(DISTINCT product) as products FROM Activities GROUP BY sell_date