조건에 맞는 도서와 저자 리스트 출력하기.sql

-- 코드를 입력하세요
SELECT BOOK.BOOK_ID,AUTHOR.AUTHOR_NAME,SUBSTRING(BOOK.PUBLISHED_DATE,1,10) AS PUBLISHED_DATE
FROM BOOK LEFT JOIN AUTHOR ON BOOK.AUTHOR_ID=AUTHOR.AUTHOR_ID
WHERE BOOK.CATEGORY='경제'
ORDER BY BOOK.PUBLISHED_DATE