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

문제

https://school.programmers.co.kr/learn/courses/30/lessons/164668

풀이

-- 코드를 입력하세요
SELECT B.USER_ID, B.NICKNAME, SUM(A.PRICE) as TOTAL_SALES
FROM USED_GOODS_BOARD A INNER JOIN USED_GOODS_USER B
ON A.WRITER_ID = B.USER_ID
WHERE 1=1
AND A.STATUS = 'DONE'
GROUP BY 1
HAVING TOTAL_SALES>=700000
ORDER BY 3