[Programmers] 조건에 맞는 도서와 저자 리스트 출력하기 (MySQL)

https://school.programmers.co.kr/learn/courses/30/lessons/144854

프로그래머스

---

🗒️ ERD

---

✏️ 제출 정답 코드

SELECT
    B.BOOK_ID AS BOOK_ID,
    A.AUTHOR_NAME AS AUTHOR_ID,
    DATE_FORMAT(B.PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATE
FROM BOOK AS B
    JOIN AUTHOR AS A
    ON B.AUTHOR_ID = A.AUTHOR_ID
WHERE B.CATEGORY = '경제'
ORDER BY B.PUBLISHED_DATE ASC;

---

📌 SQL문 정리

JOIN

[SQL] JOIN 정리 (MySQL)