1484. Group Sold Products By The Date mysql

 

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;

group by 문자열 합치기, group by 중복 제거

검색해서 문제 해결 완료