力扣SQL50 按日期分组销售产品 group_concact
Problem: 1484. 按日期分组销售产品
👨🏫 参考题解
select sell_date, count(distinct product) num_sold,group_concat(distinct product order by productseparator ',') products
from activities
group by sell_date
Problem: 1484. 按日期分组销售产品
👨🏫 参考题解
select sell_date, count(distinct product) num_sold,group_concat(distinct product order by productseparator ',') products
from activities
group by sell_date