这个题一看就可以group by,可惜sql里没有collect_list/set,直接写sql可能会变成这样:
# Write your MySQL query statement below
select
sell_date, count(product) as num_sold, product
from
Activities
group by
sell_date
但这样无法提出商品列表,只能提取一个商品。
# Write your MySQL query statement below
select
sell_date, count(distinct product) as num_sold,
group_concat(distinct product) as products
from
Activities
group by
sell_date
order by
sell_date
我们可以使用group_concat函数将商品列表变成字符串,还是挺简单的。