SIMPLE | Explanation | EASY
<<<< Please Press upvote Button !!!!!\n\nAlmost immediately detected, the only serious challange of this problem is how to aggregate the product names in one ce
**<<<< Please Press upvote Button !!!!!**\n\nAlmost immediately detected, the only serious challange of this problem is how to aggregate the product names in one cell. In MySql, this can be done using GROUP_CONCAT, in which you can also specify the sorting mechanism for the group concatenation (aggregation). The rest is simple.\n```\nselect sell_date, count( DISTINCT product ) as num_sold ,\n    \n    GROUP_CONCAT( DISTINCT product order by product ASC separator \',\' ) as products\n    \n        FROM Activities GROUP BY sell_date order by sell_date ASC;\n\n```\n![image](https://assets.leetcode.com/users/images/1a22513a-f19e-4338-b241-14a37d53c39d_1655656234.9439957.jpeg)\n
['MySQL']