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
birthyear INT
deathyear INT
book
columnName dataType
id INT
authorid INT
title VARCHAR
publishyear INT
publishinghouse VARCHAR
rating DECIMAL
bookreview
columnName dataType
bookid INT
review TEXT
author VARCHAR
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
