LC 1485. 按日期分组销售产品 (group_concat 用法)

link

select sell_date, count(distinct product) as num_sold, 
group_concat(distinct product order by product asc separator ',') as products 
from activities group by sell_date order by sell_date
原文地址:https://www.cnblogs.com/FEIIEF/p/13683944.html