You got it
select sell_date , Count(distinct product) \'num_sold\' ,\nGroup_concat(Distinct product order by product) \'products\'\nfrom activities group by sell_date;
select sell_date , Count(distinct product) \'num_sold\' ,\nGroup_concat(Distinct product order by product) \'products\'\nfrom activities group by sell_date;
[]