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

문제 설명

 

문제

 

예시

 

해결

SELECT FIRST_HALF.FLAVOR
FROM FIRST_HALF ,(SELECT FLAVOR, SUM(TOTAL_ORDER) AS TOTAL
     FROM JULY
     GROUP BY FLAVOR) AS TMP
WHERE TMP.FLAVOR = FIRST_HALF.FLAVOR
ORDER BY (TOTAL + TOTAL_ORDER) DESC
LIMIT 3;