[SQL] 주문량이 많은 아이스크림들 조회하기

반응형

 

 

https://school.programmers.co.kr/learn/courses/30/lessons/133027

프로그래머스

 

 

정답 쿼리

WITH JULY_SUM AS (
    SELECT FLAVOR, SUM(TOTAL_ORDER) TOTAL_ORDER
    FROM JULY
    GROUP BY FLAVOR
)
SELECT F.FLAVOR
FROM FIRST_HALF F
JOIN JULY_SUM J
    ON F.FLAVOR = J.FLAVOR
ORDER BY (F.TOTAL_ORDER + J.TOTAL_ORDER) DESC
LIMIT 3