1484. Group Sold Products By The Date

https://leetcode.com/problems/group-sold-products-by-the-date/

Group Sold Products By The Date - LeetCode

select sell_date, count(distinct product) as num_sold, group_concat(distinct product) as products
from Activities
group by sell_date
order by sell_date;

best

select sell_date,
count(distinct(product)) as num_sold,
group_concat(distinct(product)) as products
from activities
group by sell_date
order by sell_date

References

https://fruitdev.tistory.com/16

[MySQL] GROUP_CONCAT 사용하기