본문

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

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;