Write a query to display the book number title and number of

Write a query to display the book number, title, and number of times each book has been checked out. Limit the results to books that have been checked out more than 5 times. Sort the results in descending order by the number of times checked out, and then by title. (Figure P8.57)

Chapter 8 problem 57. Problem taken from Database Systems: Design, Implementation, and Management, 12th edition, by Carlos Coronel and Steven Morris

Solution

===========================================================
--------------
Answer:
--------------

   SELECT
       BOOK_NUM,
       BOOK_TITLE,
       Times_Checked_Out
   FROM
       BOOKS
   WHERE
       Times_Checked_Out > 5
   ORDER BY
       Times_Checked_Out DESC;
      
--------------------
Explanation:
--------------------

   The query checks all the books have been checked out more than 5 times and diplay the BOOK_NUM, BOOK_TITLE, Times_Checked_Out
from books table in descending order of Times_Checked_Out.

===========================================================