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

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

프로그래머스

 

[정답 코드]

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