For this assignment, we will be using the following relational schema for our qu

Question

For this assignment, we will be using the following relational schema for our queries.
Customer(CID, Name, Address)
Orders(Ordernum, CID, Order_date, Cardnum)
Orderlist(Ordernum, ISBN, Qty, Ship_date)
Book(ISBN, Title, Author, Qty_in_stock, Price)
When an order is placed, there is one entry added to Orders which contains the customer information and order details. Then there is one entry per book entered into Orderlist with "NULL" in the ship date which will be replaced once that line item has been shipped. Each book item will only be shipped when all the copies are present (ie: we have sufficient Qty_in_stock for the Qty of the order, that way there is a unique ship_date for each line item). Note: you can also take advantage of renaming (RA) and views (SQL) to break down some of the queries into smaller parts.

SQL Queries
11. Write a SQL QUERY which will list the ISBN and title of book which has sold the most copies in the history of our book store.

If you write a Relational Algebra Query, I will downvote.

Thank you.

Explanation / Answer

11. Write a SQL QUERY which will list the ISBN and title of book which has sold the most copies in the history of our book store.

Answer)

select ISBN, Title from Book where ISBN in (

select ISBN from Orderlist where Qty in(

select max(Qty) from Orderlist

)

);

The above subquery format first calculates the max Qty and then finds the ISBN and the Title of the Books who have the max Qty sold.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.