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

SQL_프로그래머스_조건에 맞는 사용자와 총 거래금액 조회하기 풀이 -- MYSQL SELECT UGU.USER_ID , UGU.NICKNAME , SUM(UGB.PRICE) AS TOTAL_SALES FROM USED_GOODS_USER UGU LEFT OUTER JOIN USED_GOODS_BOARD UGB ON UGU.USER_ID = UGB.WRITER_ID WHERE UGB.STATUS = 'DONE' GROUP BY UGU.USER_ID, UGU.NICKNAME HAVING TOTAL_SALES >= 700000 ORDER BY TOTAL_SALES ASC; -- ORACLE SELECT UGU.USER_ID , UGU.NICKNAME , SUM(UGB.PRICE) AS TOTAL_SALES FROM USED_GOODS_USER UGU LEFT OUTER JOIN USED_GOODS_BOARD UGB ON UGU.USER_ID = UGB.WRITER_ID WHERE UGB...

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

SQL_프로그래머스_조건에 맞는 사용자와 총 거래금액 조회하기 풀이 -- MYSQL SELECT UGU.USER_ID , UGU.NICKNAME , SUM(UGB.PRICE) AS TOTAL_SALES FROM USED_GOODS_USER UGU LEFT OUTER JOIN USED_GOODS_BOARD UGB ON UGU.USER_ID = UGB.WRITER_ID WHERE UGB.STATUS = 'DONE' GROUP BY UGU.USER_ID, UGU.NICKNAME HAVING TOTAL_SALES >= 700000 ORDER BY TOTAL_SALES ASC; -- ORACLE SELECT UGU.USER_ID , UGU.NICKNAME , SUM(UGB.PRICE) AS TOTAL_SALES FROM USED_GOODS_USER UGU LEFT OUTER JOIN USED_GOODS_BOARD UGB ON UGU.USER_ID = UGB.WRITER_ID WHERE UGB

blog.naver.com/joonbread/224200777000