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 중복 제거

검색해서 문제 해결 완료