Write a query to display the patron ID, book number, and days kept for each checkout. “Days Kept” is the difference from the date on which the book is returned to the date it was checked out. Sort the results by days kept in descending order, then by patron ID, and then by book number (Figure P7.87). (68 rows) 

Transcribed Image Text:

PATRON BOOK Days Kept 1160 5240 78 1165 5235 78 1185 5240 78 1219 5248 78 1222 5240 78 1226 5244 78 1202 5236 77 1218 5236 77 1228 5237 77 1220 5235 76 PATRON BOOK Days Kept 1160 5240 78 1165 5235 78 1185 5240 78 1219 5248 78 1222 5240 78 1226 5244 78 1202 5236 77 1218 5236 77 1228 5237 77 1220 5235 76

Answer rating: 100% (QA)

As I gone through your question about sql query You mentioned sort order all field by descanting ord... View the full answer