Leetcode 1484. 按日期分组销售产品

题目

Leetcode 1484. 按日期分组销售产品

代码（7.27 首刷看解析）

知识点
group_concat([distinct] 要连接的字段 [order by 排序字段] [separator ‘分隔符’])

# Write your MySQL query statement below
select sell_date, 
	count(distinct product) num_sold, 
	group_concat(distinct product order by product separator ',') products from Activities 
group by sell_date order by sell_date;