Problem: 1484. 按日期分组销售产品
select
sell_date,
count(distinct product) num_sold,
group_concat(distinct product
order by product
separator ',') products
from activities
group by sell_date
Problem: 1484. 按日期分组销售产品
select
sell_date,
count(distinct product) num_sold,
group_concat(distinct product
order by product
separator ',') products
from activities
group by sell_date