조건에 맞는 사용자와 총 거래금액 조회하기(Programmers)

오! 한번에 정답 ㅎㅎ

제 답 쿼리입니다.

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