Question: Write a query to display the patron ID and the average number of days that patron keeps books during a checkout. Limit the results to
Write a query to display the patron ID and the average number of days that patron keeps books during a checkout. Limit the results to only patrons who have at least three checkouts. Sort the results in descending order by the average days the book is kept (Figure P7.104).

Figure P7.104 Average Days Kept by Patron PAT_ID Average Days Kept 1160 7 1185 6.67 1165 5.67 1207 5.5 1209 5.33 1172 4.5 1183 4.33 1181 3.67 1171 3.67 1161 3.33 1210 2.33 1229 2
Step by Step Solution
3.45 Rating (158 Votes )
There are 3 Steps involved in it
To find the average days kept by patrons with at least three checkouts you ... View full answer
Get step-by-step solutions from verified subject matter experts
