Easy Oracle solution using LISTAGG
\nselect \n(to_char(sell_date,\'YYYY-MM-DD\')) as sell_date,\ncount(product) as num_sold,listagg(product,\',\') WITHIN GROUP (ORDER BY product) as products\nfro
```\nselect \n(to_char(sell_date,\'YYYY-MM-DD\')) as sell_date,\ncount(product) as num_sold,listagg(product,\',\') WITHIN GROUP (ORDER BY product) as products\nfrom (select distinct sell_date,product from Activities)\ngroup by sell_date\n```
[]