SQL 문제 12 - Group Sold Products By The Date LeetCode 1484

SQL 문제 12 - Group Sold Products By The Date LeetCode 1484 Group Sold Products By The Date 풀이 -- ORACLE SELECT TO_CHAR(A.SELL_DATE,'YYYY-MM-DD') SELL_DATE , COUNT(DISTINCT A.PRODUCT) NUM_SOLD , LISTAGG(A.PRODUCT,',') WITHIN GROUP(ORDER BY A.PRODUCT) PRODUCTS FROM (SELECT DISTINCT SELL_DATE,PRODUCT FROM ACTIVITIES) A GROUP BY A.SELL_DATE; -- MYSQL SELECT DATE_FORMAT(A.SELL_DATE,'%Y-%m-%d') SELL_DATE , COUNT(DISTINCT A.PRODUCT) NUM_SOLD , GROUP_CONCAT(DISTINCT A.PRODUCT ) PRODUCTS FROM ACTIVITIES A...

원문링크 : SQL 문제 12 - Group Sold Products By The Date LeetCode 1484