just use group_concat
\nselect \n\tsell_date, \n\tcount(distinct product) as num_sold, \n\tgroup_concat(distinct product) as products\nfrom Activities\ngroup by sell_date\norder by s
```\nselect \n\tsell_date, \n\tcount(distinct product) as num_sold, \n\tgroup_concat(distinct product) as products\nfrom Activities\ngroup by sell_date\norder by sell_date\n```
[]