Question: 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
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).

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
Step by Step Solution
3.51 Rating (158 Votes )
There are 3 Steps involved in it
To retrieve the patron ID first name and last name of patrons ... View full answer
Get step-by-step solutions from verified subject matter experts
