상반기와 7월의 맛, 주문량 뷰를 만들어서 조인한 다음 정렬해서 해결
1 2 3 4 5 6 SELECT fh.FLAVOR FROM (SELECT FLAVOR, SUM(TOTAL_ORDER) TOTAL FROM FIRST_HALF GROUP BY FLAVOR) fh, (SELECT FLAVOR, SUM(TOTAL_ORDER) TOTAL FROM JULY GROUP BY FLAVOR) j WHERE fh.FLAVOR = j.FLAVOR ORDER BY fh.TOTAL + j.TOTAL DESC LIMIT 3
1 2 3 4 5 6
SELECT fh.FLAVOR FROM (SELECT FLAVOR, SUM(TOTAL_ORDER) TOTAL FROM FIRST_HALF GROUP BY FLAVOR) fh, (SELECT FLAVOR, SUM(TOTAL_ORDER) TOTAL FROM JULY GROUP BY FLAVOR) j WHERE fh.FLAVOR = j.FLAVOR ORDER BY fh.TOTAL + j.TOTAL DESC LIMIT 3