count(DISTINCT(product)) num_sold,
group_concat(distinct product order by product separator ‘,’)
select
sell_date,
count(DISTINCT(product)) num_sold,
group_concat(distinct product order by product separator ',')
products from Activities group by sell_date order by sell_date