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

Transcribed Image Text:

Figure P7.98 Number of Checkouts for Every Book BOOK NUM 5236 Database in the Cloud 5235 Beginner's Guide to JAVA 5240 iOS Programming 5238 Conceptual Programming 5237 Mastering the database environment 5252 Beyond the Database Veil 5242 C# in Middleware Deployment 5246 Capture the Cloud 5244 Cloud-based Mobile Applications 5254 Coding Style for Maintenance 5249 Starlight Applications BOOK TITLE 5248 What You Always Wanted to Know About Database, But Were Afraid to Ask 5243 DATABASES in Theory 5239 J++ in Mobile Apps 5241 JAVA First Steps 5250 Reengineering the Middle Tier 5247 Shining Through the Cloud: Sun Programming 5245 The Golden Road to Platform independence 5251 Thoughts on Revitalizing Ruby 5253 Virtual Programming for Virtual Environments Times Checked Out 12 9 7 6 5 4 4 4 4 4 4 3 2 0 0 0 0 0 0 0