[프로그래머스 - ORACLE] 조건에 맞는 도서와 저자 리스트 출력하기

---

CREATE 문

CREATE TABLE BOOK (
BOOK_ID					NUMBER		NOT NULL,
CATEGORY				VARCHAR(10)	NOT NULL,
AUTHOR_ID				NUMBER		NOT NULL,
PRICE					NUMBER		NOT NULL,
PUBLISHED_DATE				DATE		NOT NULL
)



CREATE TABLE AUTHOR (
AUTHOR_ID				NUMBER 		NOT NULL,
AUTHOR_NAME				VARCHAR(20) 	NOT NULL
)

 

---

• 내 풀이

SELECT
    B.BOOK_ID,
    A.AUTHOR_NAME,
    TO_CHAR(B.PUBLISHED_DATE , 'YYYY-MM-DD') AS PUBLISHED_DATE
FROM BOOK B INNER JOIN AUTHOR A
ON B.AUTHOR_ID = A.AUTHOR_ID
AND B.CATEGORY = '경제'
ORDER BY B.PUBLISHED_DATE ASC;