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

# 틀렸던 코드
# select u.user_id USER_ID, u.nickname NICKNAME, sum(price) TOTAL_SALES
# from used_goods_board b left join used_goods_user u
# on (b.writer_id = u.user_id)
# where b.status = 'DONE' and b.price>=700000
# ORDER BY TOTAL_SALES asc;
# where b.status = 'DONE' and b.price>=700000
# ORDER BY TOTAL_SALES asc;


select USER_ID, NICKNAME, sum(PRICE) TOTAL_SALES
from used_goods_board b left join used_goods_user u
on b.writer_id = u.user_id
where status='done'
group by WRITER_ID
having total_sales >= 700000
order by total_sales asc;

• order by 하고 어떤 열을 기준으로 asc,desc 할건지 열! 적어주기
  order by 열이름 asc/desc

• done인 애들을 그룹묶어줘야돼서 where먼저 써줌

• from - where - group by - having - select - order by 순!!