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

Transcribed Image Text:

Figure P7.99 Books with More than Five Checkouts BOOK NUM BOOK_TITLE 5236 Database in the Cloud 5235 Beginner's Guide to JAVA 5240 iOS Programming 5238 Conceptual Programming Times Checked Out 12 2976