프로그래머스 조건에 맞는 사용자와 총 거래 금액 조회하기(MySQL)

-- 코드를 입력하세요
# SELECT USER_ID, NICKNAME, SUM(PRICE) AS TOTAL_SALES
# FROM USED_GOODS_BOARD UGB JOIN USED_GOODS_USER UGU
# ON UGB.WRITER_ID = UGU.USER_ID
# WHERE STATUS = 'DONE'
# GROUP BY USER_ID
# HAVING SUM(PRICE) >=700000
# ORDER BY TOTAL_SALES;


SELECT USER_ID, NICKNAME, SUM(PRICE) AS TOTAL_SALES
FROM USED_GOODS_BOARD AS UGB LEFT JOIN USED_GOODS_USER AS UGU
ON (UGB.WRITER_ID = UGU.USER_ID)
WHERE STATUS = 'DONE'
GROUP BY USER_ID
HAVING SUM(PRICE)>=700000
ORDER BY TOTAL_SALES;

 

왜 이렇게 쿼리를 작성해야 하는지 이해가 안된다면 실행순서를 모를 가능성이 높다

from -> where -> group by -> select -> order by 순서이다.

명심하자!