Imagine you are a database analyst working for an online bookstore. Your bookstore offers a wide selection of books, and customers can leave reviews for the books they've read. The bookstore has a database with three tables:

Tables Schema as Below:

authors

columnName dataType

id INT

name VARCHAR$(255)$

birth$\_$year INT

death$\_$year INT

book

columnName dataType

id INT

author$\_$id INT

title VARCHAR$(255)$

publish$\_$year INT

publishing$\_$house VARCHAR$(255)$

rating DECIMAL$(3,2)$

book$\_$review

columnName dataType

book$\_$id INT

review TEXT

author VARCHAR$(255)$

Your manager has asked you to retrieve information about all the books, including their reviews and review author names, even if a book hasn't been reviewed yet. This is valuable because it allows the bookstore to provide a comprehensive list of books to customers, along with any available reviews. It also helps in marketing books and encouraging customers to leave more reviews.