【SQL】1484. 按日期分组销售产品 ( group_concat()函数 )

提交

# Write your MySQL query statement below

select sell_date, 
       COUNT(distinct product) as num_sold,
    #    group_concat(distinct product) as products  # 简写
       group_concat(distinct product order by product asc Separator ',') as products
from Activities
group by sell_date
order by sell_date;

group_concat()

# group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符'])
# group_concat(distinct product order by asc Separator ',')