ms sql solution with string_agg
Please note that this solution with string_agg will work only from SQL Server 2017 and above and SQL Azure\n\nselect sell_date, count(product) as \'num_sold\', 
Please note that this solution with `string_agg` will work only from SQL Server 2017 and above and SQL Azure\n```\nselect sell_date, count(product) as \'num_sold\', string_agg(product, \',\') as products\nfrom\n(\n    select distinct *\n    from Activities\n) t\ngroup by sell_date\n```
['MS SQL Server']