Write a query to display the patron ID, full name (first and last), and patron type for all patrons. Sort the results by patron type and then by last name and first name. Ensure that all sorting is case insensitive (Figure P7.94). (50 rows) 

Transcribed Image Text:

Figure P7.94 Sorted Patrons with Full Names PAT ID NAME 1165 Cedric Baldwin 1170 Cory Barry 1160 robert carter PAT_TYPE 1166 Vera Alvarado 1202 Holly Anthony 1180 Nadine Blair Faculty faculty Faculty 1183 Helena Hughes Faculty 1161 Kelsey Koch Faculty 1167 Alan Martin FACULTY Student Student STUDENT