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

| 문제

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

프로그래머스

 

| 풀이

SELECT U.USER_ID AS USER_ID, U.NICKNAME AS NICKNAME, SUM(B.PRICE) AS TOTAL_PRICE
FROM USED_GOODS_BOARD B JOIN USED_GOODS_USER U
ON B.WRITER_ID = U.USER_ID
WHERE B.STATUS = 'DONE'
GROUP BY B.WRITER_ID
HAVING SUM(B.PRICE) >= 700000