Write a query to display the patron ID and first and last name of all patrons who have never checked out any book. Sort the result by patron last name and then first name (Figure P7.101).

Transcribed Image Text:

Figure P7.101 Patrons Who Never Checked Out a Book 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 1243 Roberto 1242 Mario 1237 Brandi 1167 Alan 1182 Jamal 1201 Shelby 1244 Leon 1200 Lorenzo 1241 Irene King Larson Martin Melendez Noble Richmond Torres West