[leetcode] 1484. Group Sold Products By The Date / GROUP_CONCAT

1484. Group Sold Products By The Date

 

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

Group Sold Products By The Date - LeetCode

 

Write an SQL query to find for each date the number of different products sold and their names.

The sold products names for each date should be sorted lexicographically.

Return the result table ordered by sell_date.

The query result format is in the following example.

 

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

 

 

2022.12.14 - [🛠️Skill/SQL] - [SQL문법] GROUP_CONCAT 그룹별 집계

[SQL문법] GROUP_CONCAT 그룹별 집계