👩‍💻 문제

https://school.programmers.co.kr/learn/courses/30/lessons/133027#qna

🙋‍♀️ 답변

WITH CTE AS 
(SELECT FLAVOR, SUM(TOTAL_ORDER) AS TOTAL1
FROM FIRST_HALF
GROUP BY FLAVOR
UNION ALL
SELECT FLAVOR, SUM(TOTAL_ORDER) AS TOTAL2
FROM JULY
GROUP BY FLAVOR)

SELECT FLAVOR
FROM F
GROUP BY FLAVOR
ORDER BY SUM(TOTAL1) DESC
LIMIT 3;

🤔

MySQL에는 full outer join이 없단다 !!! 좀 만들어주라 .ㅋ.ㅋ
오라클에는 있는데!!!
암튼 그래서 full outer join을 하기 위해서는 left join과 right join을 union 하면 된다.