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
posted @ 2020-09-17 11:04  feibilun  阅读(144)  评论(0编辑  收藏  举报