리트코드(LeetCode) SQL - 1484. Group Sold Products By The Date

 

select sell_date, COUNT(distinct product) as num_sold,GROUP_CONCAT(distinct product order by product)  as products
    from Activities group by sell_date
    order by 1;