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)
PAT ID NAME PAT TYPE 1165 Cedric Baldwin Faculty 1170 Cory Barry faculty 1160 robert carter Faculty 1183 Helena Hughes Faculty 1161 Kelsey Koch Faculty 1167 Alan Martin FACULTY 1166 Vera Alvarado Student 1202 Holly Anthony Student 1180 Nadine Blair STUDENT 1238 Erika Bowen Student
