[프로그래머스] 조건에 맞는 도서 리스트 출력하기 Lv.1

 

SELECT BOOK_ID, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') as PUBLISHED_DATE

FROM BOOK

WHERE CATEGORY = '인문'

AND PUBLISHED_DATE BETWEEN '2021-01-01 00:00:00'  AND '2021-12-31 00:00:00'

ORDER BY PUBLISHED_DATE