본문 바로가기

문제풀이/프로그래머스 SQL 문제

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

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

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