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, MB$-$date, 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 that have any inspections scheduled after $1-$JAN$-2014.$ Do not display the same information more than once.E$5\mathrm{.}2$g$$Display the SMemberID and SMemberName of staff members cleaning apartments rented by corporate clients whose corporate location is Chicago. Do not display the same information more than once.E$5\mathrm{.}2$h$$Display the CCName of the client and the CCName of the client who referred him or her, for every client referred by a client in the Music industry.E$5\mathrm{.}2$i$$Display the BuildingID, AptNo, and ANoOfBed$-$rooms for all apartments that are not leased.