Simple and Easy Solution using group_concat
\nSELECT \n    sell_date,\n    count(DISTINCT(product)) as num_sold,\n    GROUP_CONCAT( DISTINCT product) as products\nfrom Activities \nGroup by sell_date;\n\n
```\nSELECT \n    sell_date,\n    count(DISTINCT(product)) as num_sold,\n    GROUP_CONCAT( DISTINCT product) as products\nfrom Activities \nGroup by sell_date;\n```\n\n**Please UpVote if it was Helpful :)**
['MySQL']