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

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

1 Expert Approved Answer
Step: 1 Unlock

To find the average days kept by patrons with at least three checkouts you ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database Systems Design Implementation Questions!