Question

E5.2 (no queries). Write the SQL queries that accomplish the following tasks in the HAFH Realty Company Property Manage- ment Database: E5.2a Display the SMemberID and SMemberName for all staff members. E5.2b Display the CCID, CCName, and CCIndustry for all corporate clients. E5.2c Display the BuildingID, BNoOfFloors, and the manager's MFName and MLName for all buildings. E5.2d Display the MFName, MLName, MSalary, MB- date, and number of buildings that the manager manages for all managers with a salary less than $55,000. E5.2e Display the BuildingID and AptNo for all apart- ments leased by the corporate client WindyCT. E5.2f Display the InsID and InsName for all inspectors that have any inspections scheduled after 1-JAN- 2014. Do not display the same information more than once. E5.2g Display the SMemberID and SMemberName of staff members cleaning apartments rented by cor- porate clients whose corporate location is Chicago. on than

Answer 1

2a) SELECT * FROM STAFFMEMBER;

2b) SELECT CCID,CCName,CCIndustry,CCLocation,CCIDReferredBy FROM CORPCLIENT;

2c) SELECT BuildingID,BNoOfFloors FROM BUILDING UNION SELECT MFName,MLName FROM MANAGER;

2d) SELECT A.MFName,A.MLName,A.MSalary,A.MBdate,B.BNoOfFloors FROM MANAGER,BUILDING WHER A.ManagerID=B.ManagerID AND MSalary < 50000;