SQL SERVER Solution
it works well, and Don\'t forgot to upvote\n\nthis below line do magic\n\nstring_agg(product,\',\') within group (order by product asc) as products \n\n# Code\n
it works well, and **Don\'t forgot to upvote**\n\nthis below line do magic\n\n**string_agg(product,\',\') within group (order by product asc) as products **\n\n# Code\n```\n/* Write your T-SQL query statement below */\nselect sell_date, \n        count(distinct product) as num_sold,\n        string_agg(product,\',\') within group (order by product asc) as products\nfrom(select distinct sell_date,product from Activities)sq \ngroup by sell_date \norder by sell_date\n```
['MS SQL Server']