Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Imagine you are managing a database for a bookstore. The table book _ sales contains information about sales transactions. Each row represents a sale, including
Imagine you are managing a database for a bookstore. The table booksales contains information about sales transactions. Each row represents a sale, including the book's title, the quantity sold, the sale date, and the total revenue generated. Your task is to write a query that retrieves the books that have a total quantity sold greater than and an average revenue per book greater than $
The average Revenue generated should be rounded to two decimal places.
Output the results in descending order of average revenue per book.
Tables Schema as Below:
booksales
columnName dataType
saleid INT
booktitle VARCHAR
quantitysold INT
saledate DATE
totalrevenue INT
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started