LeetCode_Study_Plan/SQL
1484. Group Sold Products By The Date mysql
개발하는루루
2022. 9. 27. 12:44
https://leetcode.com/problems/group-sold-products-by-the-date/
Group Sold Products By The Date - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
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 중복 제거
검색해서 문제 해결 완료