EASY WAY USING GROUP_CONCAT
\n# Code\nmysql []\nselect sell_date,\ncount(distinct product)as num_sold,\ngroup_concat(distinct product order by product) as products\nfrom Activities \ngroup
\n# Code\n```mysql []\nselect sell_date,\ncount(distinct product)as num_sold,\ngroup_concat(distinct product order by product) as products\nfrom Activities \ngroup by sell_date\norder by sell_date;\n```
['MySQL']