select author.name,book.title from author left join book_author on author.id = book_author.author_id left join book on book_author.book_id = book.id;
select author.name,book.title from author left join book_author on author.id = book_author.author_id left join book on book_author.book_id = book.id;