SQL프로그래머스 문제풀이 - 조건에 맞는 사용자와 총 거래금액 조회하기

SELECT USER_ID, NICKNAME, sum(PRICE) as TOTAL_SALES
from USED_GOODS_BOARD as B
inner join USED_GOODS_USER as U
on B.WRITER_ID = U.USER_ID
where STATUS = 'DONE'
group by USER_ID
having TOTAL_SALES >= 700000
order by TOTAL_SALES

#SELECT 에 출력할칼럼작성
#FROM, inner join, on으로 데이터를 합쳐주고 별칭을 지정해준다 on을 사용한 이유 합칠칼럼의 이름이 다르다
#status칼럼이 done인 것을 조건화해주고
#USER_ID 별로 볼거니까 group by 해준다
#having에 TOTAL_SALES 700000이상인 칼럼 조건화 한번 더 해주고
#order by TOTAL_SALES로 오름차순정리