You must use the Access database and create queries that will answer the request

Question

You must use the Access database and create queries that will answer the requests below.
You may use direct SQL to create the queries.
Store them using the number of the question (Q1, Q2, etc.).

Question: Obtain the ranking of all categories of books by the total quantity that was ordered, from the most ordered to the least ordered.

We're not using Join or Join In functions. Just SELECT, FROM, WHERE, ORDER BY, and SORT BY Thanks!

Book Wrote Author Authorid AuthornD FrstName nitials Category AuthorRank OrderLine Order Customer OrderNo OrderRank ISEN CustomerName CustomerAddress Stato OrderDeliveryCate Quanbty PercentageOiscount

Explanation / Answer

select Category from Book b where b.ISBN = (select ISBN from OrderLine group by ISBN order by count(o.quantity) desc) ;

With the inner query, we are fetching the count of books per ISBN in descending order and then using the ISBN to get the category wise sort.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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