simple and easy
select sell_date,count(distinct product) num_sold,group_concat(distinct product) products from activities group by sell_date order by sell_date
select sell_date,count(distinct product) num_sold,group_concat(distinct product) products from activities group by sell_date order by sell_date
['MySQL']