2 Simple SQL Solutions: Group_Concat() and String_Agg()
\nSELECT \n  sell_date,\n  COUNT(product) AS num_sold,\n  STRING_AGG(product, \',\') WITHIN GROUP (ORDER BY product ASC) AS products\nFROM (SELECT DISTINCT * FR
```\nSELECT \n  sell_date,\n  COUNT(product) AS num_sold,\n  STRING_AGG(product, \',\') WITHIN GROUP (ORDER BY product ASC) AS products\nFROM (SELECT DISTINCT * FROM Activities) T\nGROUP BY sell_date\nORDER BY 1 ASC\n```\n\n```\nSELECT \n    sell_date,\n    COUNT(DISTINCT product) AS num_sold,\n    GROUP_CONCAT(DISTINCT product ORDER BY product ASC) AS products\nFROM Activities\nGROUP BY sell_date\nORDER BY 1 ASC\n```
[]