Write a query to display the patron ID, last name, number of times that patron has ever checked out a book, and the number of different books the patron has ever checked out. For example, if a given patron has checked out the same book twice, that would count as two checkouts but only one book. Limit the results to only patrons who have made at least three checkouts. Sort the results in descending order by number of books, then in descending order by number of checkouts, and then in ascending order by patron ID (Figure P7.102).

Transcribed Image Text:

Figure P7.102 Checkouts and Books by Patron PAT_ID PAT_LNAME NUM CHECKOUTS NUM DIFFERENT BOOKS 1161 Koch 1165 Baldwin 1181 Horne 1185 Yang 1210 Cooley 1229 Burke 1160 carter 1171 Marsh 1172 Miles 1207 Ramos 1209 Mathis 1183 Hughes 3 3 3 3 MMMMMMMMM لا لا لا لا لا لا لا لا لا 3 3 3 3 3 3 3 3 لا لا لا 333 3 3 3 NNNNN@@@ 3 3 2 2 2 2 2 1