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 five times. Sort the results in descending order by the number of times checked out and then by title. 

   

Transcribed Image Text:

CHECKOUT PK Check Num FK1 Book Num FK2 Pat_ID Check Out Date Check Due Date Check_In_Date BOOK PK Book Num Book Title Book_Year Book Cost Book Subject FK1 Pat_ID HH PO-----H- PATRON PK Pat ID Pat FName Pat LName Pat_Type 1 I WRITES PK,FK1 Book Num +PK,FK2 AU ID AUTHOR PK AU ID Au FName Au_LName Au_BirthYear CHECKOUT PK Check Num FK1 Book Num FK2 Pat_ID Check Out Date Check Due Date Check_In_Date BOOK PK Book Num Book Title Book_Year Book Cost Book Subject FK1 Pat_ID HH PO-----H- PATRON PK Pat ID Pat FName Pat LName Pat_Type 1 I WRITES PK,FK1 Book Num +PK,FK2 AU ID AUTHOR PK AU ID Au FName Au_LName Au_BirthYear

Answer rating: 100% (QA)

SELECT BOOKNUM BOOKTITLE TimesCheckedOut FROM BOOKS WHERE T... View the full answer