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

문제

MYSQL

내가 작성한 정답

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

ORACLE

내가 작성한 오답

SELECT FLAVOR
FROM (SELECT SUM(J.TOTAL_ORDER)+F.TOTAL_ORDER AS P,J.FLAVOR
        FROM FIRST_HALF F
        JOIN JULY J ON F.FLAVOR = J.FLAVOR
        GROUP BY J.FLAVOR, F.TOTAL_ORDER
        ORDER BY P DESC) AS TB
WHERE ROWNUM <= 3;

내가 작성한 정답

SELECT FLAVOR
FROM (SELECT SUM(J.TOTAL_ORDER)+F.TOTAL_ORDER AS P,J.FLAVOR
        FROM FIRST_HALF F
        JOIN JULY J ON F.FLAVOR = J.FLAVOR
        GROUP BY J.FLAVOR, F.TOTAL_ORDER
        ORDER BY P DESC) TB
WHERE ROWNUM <= 3;