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

 

 

 

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