Write a query to display the patron ID, book number, and days kept for each checkout. Days

Question:

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). 

Figure P7.87 Days Kept PATRON BOOK Days Kept 1160 5240 1160 5240 1165 5235 1183 5236 1184 5240 1185 5240 1202

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: