1485 按照日期分组销售产品 group_concat() 列抓行（没写出来）

Create table If Not Exists Activities (sell_date date, product varchar(20))
Truncate table Activities
insert into Activities (sell_date, product) values ('2020-05-30', 'Headphone')
insert into Activities (sell_date, product) values ('2020-06-01', 'Pencil')
insert into Activities (sell_date, product) values ('2020-06-02', 'Mask')
insert into Activities (sell_date, product) values ('2020-05-30', 'Basketball')
insert into Activities (sell_date, product) values ('2020-06-01', 'Bible')
insert into Activities (sell_date, product) values ('2020-06-02', 'Mask')
insert into Activities (sell_date, product) values ('2020-05-30', 'T-Shirt')

技术补充：
HIVE SQL : 列转行：


mysql 列转行

select  sell_date,count(*) as 'num_sold' ,
group_concat(distinct product ) as 'products'
from  Activities
group by sell_date
order by sell_date,product