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

문제

MYSQL,ORACLE

내가 작성한 정답

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