Write a query to display the book number and the number of times each book has been checked out. Do not include books that have never been checked out. Sort the results by the number of times checked out in descending order and then by book number in descending order (Figure P7.95).

Transcribed Image Text:

Figure P7.95 Times Checked Out BOOK NUM Times Checked Out 5236 12 5235 9 5240 7 5238 6 5237 5 5254 4 5252 5249 5246 5244 5242 5248 5243 4 4 4 4 4 32