풀이 코드
SELECT BOOK_ID,
DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATE
FROM BOOK
WHERE CATEGORY = "인문" AND PUBLISHED_DATE LIKE "2021%"
ORDER BY PUBLISHED_DATE;
항상 성장하는 개발자 최동혁입니다.
SELECT BOOK_ID,
DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATE
FROM BOOK
WHERE CATEGORY = "인문" AND PUBLISHED_DATE LIKE "2021%"
ORDER BY PUBLISHED_DATE;