concat 95%
\nselect\n    sell_date, \n    count(distinct product) as num_sold, \n    group_concat(distinct product order by product asc) as products \nfrom \n    activitie
```\nselect\n    sell_date, \n    count(distinct product) as num_sold, \n    group_concat(distinct product order by product asc) as products \nfrom \n    activities \ngroup by \n    sell_date\norder by \n    sell_date \n```\n\nif you like this, please upvote.
[]