#122. [LeetCode / MySQL] 1484. Group Sold Products By The Date

문제

 

 

입력 코드

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

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

 

 

코드 설명

#SELECT #COUNT #DISTINCT #GROUP_CONCAT #GROUP BY #ORDER BY

 

 

GROUP_CONCAT()

• GROUP_CONCAT(컬럼명)
• GROUP_CONCAT(DISTINCT 컬럼명) : 중복 제거
• GROUP_CONCAT(컬럼명 SEPERATOR '구분자') : 구분자 변경
• GROUP_CONCAT(컬럼명 ORDER BY 컬럼명)  : 문자열 정렬

 

문제 출처

https://leetcode.com/problems/group-sold-products-by-the-date/description/?envType=study-plan-v2&envId=top-sql-50