Use the ch08fact database shown in figure p844 for problems


Question: Use the Ch08_Fact database shown in Figure P8.44. For problems with very large results sets, only the first several rows of output are shown in the following figures.

342_8.44.png

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, then by last name and first name. Ensure that all sorting is case insensitive. (Figure P8.52)

291_8.52.png

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Use the ch08fact database shown in figure p844 for problems
Reference No:- TGS02324749

Expected delivery within 24 Hours