[LeetCode] 1484. Group Sold Products By The Date

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT sell_date
     , COUNT(DISTINCT product) AS num_sold
     , GROUP_CONCAT(DISTINCT product ORDER BY product ASC) AS products
FROM Activities
GROUP BY sell_date