select sell_date,count(distinct(product)) as num_sold
,group_concat(distinct product order by product separator ',') as products
from Activities
group by (sell_date)
order by sell_date ASC
高频 SQL 50 题（基础版）_1484. 按日期分组销售产品
select sell_date,count(distinct(product)) as num_sold
,group_concat(distinct product order by product separator ',') as products
from Activities
group by (sell_date)
order by sell_date ASC
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
