simple mysql answer
answer 1\n> Runtime: 729 ms, faster than 25.00% of MySQL online submissions for Group Sold Products By The Date.\nMemory Usage: 0B, less than 100.00% of MySQL o
# answer 1\n> Runtime: 729 ms, faster than 25.00% of MySQL online submissions for Group Sold Products By The Date.\nMemory Usage: 0B, less than 100.00% of MySQL online submissions for Group Sold Products By The Date.\n\n```sql\nselect \n\tsell_date, \n\tCOUNT(product) num_sold,  \n\tgroup_concat(product order by product) products \nfrom (SELECT DISTINCT * FROM Activities) Activities\ngroup by sell_date\norder by sell_date\n```\n# answer 2\n> Runtime: 656 ms, faster than 35.06% of MySQL online submissions for Group Sold Products By The Date.\nMemory Usage: 0B, less than 100.00% of MySQL online submissions for Group Sold Products By The Date.\n\n```sql\nselect \n    sell_date, COUNT(DISTINCT product) num_sold, \n    group_concat(DISTINCT product) products \nfrom Activities\ngroup by sell_date\norder by sell_date\n```
[]