#1484 Group Sold Products By The Date
SELECT sell_date, 
    COUNT(DISTINCT product) AS num_sold, 
    GROUP_CONCAT(DISTINCT product) as products
FROM Activities
GROUP BY sell_dateLast updated
Was this helpful?
SELECT sell_date, 
    COUNT(DISTINCT product) AS num_sold, 
    GROUP_CONCAT(DISTINCT product) as products
FROM Activities
GROUP BY sell_dateLast updated
Was this helpful?