Your assignment is to write and run SQL queries that will produce the data $($record sets$)$ requested below using the small HAFH database. $(1)$ SQL statement $($as text$),$ and $(2)$ the Recordset $($your output$/$results$)$ from each SQL statement When you have finished, please submit this Word document $($with your SQL statements and output copied into it$).$ You may want to use the $$Snipping Tool$$ to copy the recordset $($output$).$ E$5\mathrm{.}2$ Write the SQL queries that accomplish the following tasks in the HAFH Realty Company Property Management Database: E$5\mathrm{.}2$a Display the SMemberID and SMemberName for all staff members. E$5\mathrm{.}2$b Display the CCID, CCName, and CCIndustry for all corporate clients. E$5\mathrm{.}2$c Display the BuildingID, BNoOfFloors, and the manager$$s MFName and MLName for all buildings. E$5\mathrm{.}2$d Display the MFName, MLName, MSalary, MBDate, and number of buildings that the manager manages for all managers with a salary less than $$55,000.$ E$5\mathrm{.}2$e Display the BuildingID and AptNo, for all apartments leased by the corporate client WindyCT. E$5\mathrm{.}2$f Display the InsID and InsName for all inspectors whose next inspection is scheduled after $1-$JAN$-2014.$ Do not display the same information more than once.