프로그래머스 SQL 문제풀이(Oracle)/SQL LV3(Oracle)
조건에 맞는 사용자와 총 거래금액 조회하기
빛하루
2023. 9. 2. 16:48
SELECT F.USER_ID, F.NICKNAME, SUM(B.PRICE) AS TOTAL_SALES
FROM USED_GOODS_BOARD B, USED_GOODS_USER F
WHERE (B.WRITER_ID = F.USER_ID)
AND
B.STATUS = 'DONE'
GROUP BY F.USER_ID, F.NICKNAME
HAVING SUM(B.PRICE) >= 700000
ORDER BY TOTAL_SALES;