Write a query to display the checkout number, book number, patron ID, checkout date, and due date for every checkout that has ever occurred in the system. Sort the results by checkout date in descending order and then by checkout number in ascending order (Figure P7.63).

Transcribed Image Text:

Figure P7.63 Checkouts by Date CHECK_NUM BOOK_NUM PAT_ID CHECK_OUT_DATE CHECK_DUE_DATE 5252 1229 5238 1229 5242 1228 5236 1183 5244 1210 5235 1209 5246 1172 5254 1223 5243 1223 5254 1224 91067 91068 91066 91064 91065 91060 91061 91062 91063 91056 5/24/2021 5/24/2021 5/19/2021 5/17/2021 5/17/2021 5/15/2021 5/15/2021 5/15/2021 5/15/2021 5/10/2021 5/31/2021 5/31/2021 5/26/2021 5/31/2021 5/24/2021 5/22/2021 5/22/2021 5/22/2021 5/22/2021 5/17/2021