Oracle Solution - LISTAGG
\nWITH cte as(\nselect distinct sell_date, product from Activities)\n\nselect TO_CHAR(sell_date,\'YYYY-MM-DD\') as sell_date, count(product) as num_sold,\nLISTA
```\nWITH cte as(\nselect distinct sell_date, product from Activities)\n\nselect TO_CHAR(sell_date,\'YYYY-MM-DD\') as sell_date, count(product) as num_sold,\nLISTAGG(product, \',\') WITHIN GROUP (ORDER BY product) as products\nfrom cte\ngroup by sell_date\norder by sell_date\n```
['Oracle']