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

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

1 Expert Approved Answer
Step: 1 Unlock

To retrieve the patron ID first name and last name of patrons ... 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!