LeetCode Group Sold Products By The Dateを解いてみた

問題

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

解いた

GROUP_CONCAT関数を初めて知った。

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

qiita.com

結果