[프로그래머스_SQL] 조건에 맞는 사용자와 총 거래금액 조회하기

📜문제

---

https://school.programmers.co.kr/learn/courses/30/lessons/164668

📜정답

---

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

📜노트

---

• SUM

덧셈 함수