GROUP_CONCAT ( ) FASTER THAN 95%
\nSELECT sell_date, \nCOUNT(DISTINCT product) num_sold, \nGROUP_CONCAT(DISTINCT product) as products\nFROM Activities\nGROUP BY 1\n\n\nI am not sure if we have 
```\nSELECT sell_date, \nCOUNT(DISTINCT product) num_sold, \nGROUP_CONCAT(DISTINCT product) as products\nFROM Activities\nGROUP BY 1\n```\n\nI am not sure if we have to use ORDER BY within GROUP_CONCAT as it returns the order lexicographically on its own. My assumption is that ---> ASC order is by default if you dont mention the ORDER BY in this clause. And also we dont need a SEPARATOR as the GROUP_CONCAT adds a \',\' between values by default. \n\nI can be wrong so please correct me if anyone knows more about this.
[]