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

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

SELECT u.USER_ID, u.NICKNAME, sum(b.PRICE) as TOTAL_SALES
from USED_GOODS_BOARD b, USED_GOODS_USER u
where b.WRITER_ID = u.USER_ID
and b.STATUS = "DONE"
group by u.USER_ID
having TOTAL_SALES >= 700000
order by TOTAL_SALES