조건에 맞는 도서 리스트 출력하기(Mysql)

문제

풀이

SELECT BOOK_ID, date_format(PUBLISHED_DATE, '%Y-%m-%d') as PUBLISHED_DATE from BOOK 
where CATEGORY = '인문'
# and date_format(PUBLISHED_DATE, '%Y') = '2021' # 방법1
# and PUBLISHED_DATE like '%2021%'  # 방법2
# and YEAR(PUBLISHED_DATE) = 2021   # 방법3
# AND YEAR(PUBLISHED_DATE) = '2021' # 방법4
# AND SUBSTR(DATE_FORMAT(PUBLISHED_DATE,'%Y-%m-%d'),1,4) = '2021' # 방법 5
order by PUBLISHED_DATE asc