easy solution - distinct, group_concat, group by
SELECT sell_date, count(distinct product) as num_sold, group_concat(distinct product) as products\nFROM activities\nGROUP BY sell_date;
SELECT sell_date, count(distinct product) as num_sold, group_concat(distinct product) as products\nFROM activities\nGROUP BY sell_date;
[]