#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_date

Last updated

Was this helpful?