SQL | Easy to Understand | Using GROUP_CONCAT
\nSELECT sell_date, \n    count(DISTINCT product) as num_sold,\n    GROUP_CONCAT(DISTINCT product ORDER BY product) AS products\nFROM Activities \nGROUP BY sell
```\nSELECT sell_date, \n    count(DISTINCT product) as num_sold,\n    GROUP_CONCAT(DISTINCT product ORDER BY product) AS products\nFROM Activities \nGROUP BY sell_date \nORDER BY sell_date;\n```\nPlease upvote if you found this useful :)
['MySQL']