Question: 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

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)
Find the title and rating of the book with the highest rating that doesn't have a review.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!