In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the original Solmaris Condominium Group database so your data will not reflect the changes you made in Chapter 3.) MUST BE ANSWERED IN SQL QUERY CODE.

a) List the unit number for every condo and whether or not there is a service request.

b) List the owners last name, location number, unit number, square footage, and condo fee for only those units with a service request. Group the results by location number. Sort the results by condo fee and then by the square footage.

c) List the EstHours and SpentHours for every condo with a service request. Then calculate the difference between the estimated time for service and the hours actually spent on service and call the calculated field TimeSaved.

d) Assume the CondoUnit table has been created, but there were no integrity constraints. Create the necessary integrity constraints to relate the CondoUnit table to the Owner table using the OwnerNum field. You must write both the Primary Key and Foreign Key statements.

e) Show each state and a count of all the unit numbers in each state; but only where the count is greater than 1.