SQL

✏️ Programmers MySQL 정답률 55~65% 전체 풀이 1️⃣ 주문량이 많은 아이스크림들 조회하기 (https://school.programmers.co.kr/learn/courses/30/lessons/133027) SELECT FH.FLAVOR FROM FIRST_HALF AS FH INNER JOIN ( SELECT FLAVOR, SUM(TOTAL_ORDER) AS TOTAL FROM JULY GROUP BY FLAVOR ) AS SUB ON FH.FLAVOR = SUB.FLAVOR ORDER BY (TOTAL_ORDER + TOTAL) DESC LIMIT 3; SELECT FH.FLAVOR FROM FIRST_HALF AS FH JOIN JULY AS J ON FH.FLAVOR = J..