gROUP sOLD PRODUCT BY DATE

[Antim-IWP]

1484. Group Sold Products By The Date

[iamAntimPal]

select sell_date, count( DISTINCT product ) as num_sold ,
    
    GROUP_CONCAT( DISTINCT product order by product ASC separator ',' ) as products
    
        FROM Activities GROUP BY sell_date order by sell_date ASC;

EXPLANATION