Write a query to display the patron ID, first and last name of all patrons that have never checked out any book. Sort the result by patron last name and then first name. (See the figure below for the...

1. Write a query to display the patron ID, first and last name of all patrons that have never checked out any book. Sort the result by patron last name and then first name. (See the figure below for the output)


2. 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. (See the figure below for the output)

Extracted text: 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


Extracted text: PAT ID PAT_FNAME PAT LNAME 1166 Vera Alvarado 1180 Nadine Blair 1238 Erika Bowen 1208 Ollie Cantrell 1227 Alicia Dickson 1205 Claire Gomez 1239 Elton Irwin 1240 Jan Joyce Kennedy King 1243 Roberto 1242 Mario 1237 Brandi Larson 1167 Alan Martin 1182 Jamal Melendez 1201 Shelby Noble 1244 Leon Richmond 1200 Lorenzo Torres 1241 Irene West