Please help solve, showing SQL queries. The ER Diagrams and relational schema are shown.

1) Display the SMemberID, SMemberName, and the number of apartments that the staff member cleans, for all staff members.

2) 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.

Thank you!

HAFHMORE ERD and Relational Schema InsID INSPECTOR DateNext InsName CCID CCIndustry Inspects Datelast Artio NoOfBedrooms CCName CCLocation BuildingID BUILDING Locatedin Leases APARTMENT (5,10) -0H CORPCLIENT BNoOfFloors Residesin Cleans Refers Manages (1.2) STAFFMEMBER Manager ID MANAGER MSalary MPhone MBonus (0) sMemberID SMemberName MAge MBdate (MFullName MFirstName MLastName INSPECTING InsID (FK) Building ID (FK) Datelast DateNext CLEANING INSPECTOR InsID InsName BUILDING Building ID BNoOfFloors BManagerID (FK Building ID ] MANAGER Manager ID MFirstName MLastName MBdate MSalary MBonus (0) MResBuildingID (FK) AptNo SMemberID (FK) APARTMENT Building ID (FK) AptNo ANoOfBedrooms CCID (C)(FK) STAFFMEMBER SMemberID SMemberName MANAGERPHONE Manager ID (FK) MPhone CORPCLIENT CCID CCName (U) CCIndustry CCLocation CCIDReferredBy COXFK)