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

• WITH VALUE AS (...)+UNION를 활용한 풀이

WITH VALUE AS(
(
    SELECT FLAVOR, TOTAL_ORDER
    FROM FIRST_HALF 
)
UNION
(
    SELECT FLAVOR, TOTAL_ORDER
    FROM JULY
))
SELECT FLAVOR
FROM VALUE
GROUP BY FLAVOR
ORDER BY SUM(TOTAL_ORDER) DESC
LIMIT 3;

• JOIN만을 활용한 풀이

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