SQL_프로그래머스_카테고리 별 도서 판매량 집계하기

SQL_프로그래머스_카테고리 별 도서 판매량 집계하기 풀이 -- MYSQL SELECT B.CATEGORY , SUM(BS.SALES) AS TOTAL_SALES FROM BOOK B JOIN BOOK_SALES BS ON B.BOOK_ID = BS.BOOK_ID WHERE DATE_FORMAT(BS.SALES_DATE, '%Y%m') = '202201' GROUP BY B.CATEGORY ORDER BY CATEGORY; -- ORACLE SELECT B.CATEGORY , SUM(BS.SALES) AS TOTAL_SALES FROM BOOK B JOIN BOOK_SALES BS ON B.BOOK_ID = BS.BOOK_ID WHERE TO_CHAR(BS.SALES_DATE, 'YYYYMM') = '202201' GROUP BY B.CATEGORY ORDER BY CATEGORY; CATEGORY별 총 판매량을 체크하는데.. CATEGORY는 BOOK 테이블, 판매량은 BOOK_S...

SQL_프로그래머스_카테고리 별 도서 판매량 집계하기

SQL_프로그래머스_카테고리 별 도서 판매량 집계하기 풀이 -- MYSQL SELECT B.CATEGORY , SUM(BS.SALES) AS TOTAL_SALES FROM BOOK B JOIN BOOK_SALES BS ON B.BOOK_ID = BS.BOOK_ID WHERE DATE_FORMAT(BS.SALES_DATE, '%Y%m') = '202201' GROUP BY B.CATEGORY ORDER BY CATEGORY; -- ORACLE SELECT B.CATEGORY , SUM(BS.SALES) AS TOTAL_SALES FROM BOOK B JOIN BOOK_SALES BS ON B.BOOK_ID = BS.BOOK_ID WHERE TO_CHAR(BS.SALES_DATE, 'YYYYMM') = '202201' GROUP BY B.CATEGORY ORDER BY CATEGORY; CATEGORY별 총 판매량을 체크하는데.. CATEGORY는 BOOK 테이블, 판매량은 BOOK_S

blog.naver.com/joonbread/224194547300