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

 

   SELECT  b.book_id, a.author_name, 
           DATE_FORMAT(published_date, '%Y-%m-%d') AS published_date
     FROM  book as b
LEFT JOIN  author as a 
       ON  b.author_id = a.author_id
    WHERE  b.category = '경제'
    ORDER
       BY  b.published_date;