Request $1$: Retrieve the managerid, mfname, mlname, and the sum of msalary and mbonus for

each manager who receives a bonus.

$(1)$ Provide the SQL query for the request.

$(2)$ Provide the corresponding result in a table format $($NOT a screenshot$).$

$(3)$ Identify the number of managers in the table and the full name$($s$)$ of the manager$($s$)$ with

the least and the largest sum of msalary and mbonus $($Not a SQL query$).$

Request $2$: For each building, retrieve the buildingid, number of apartments in the building, and

number of bedrooms in the building.

$(1)$ Provide the SQL query for the request.

$(2)$ Provide the corresponding result in a table format.

$(3)$ Identify the buildingid$($s$)$ with the least apartments, and the buildingid$($s$)$ with the most

bedrooms.

Request $3$: For each staff member, retrieve the smemberid, smembername, and number of

buildings where s$/$he cleans apartments.

$(1)$ Provide the SQL query for the request.

$(2)$ Provide the corresponding result in a table format.

$(3)$ Identify the smembername$($s$)$ with the most buildings where he$/$she cleans apartments,

and the smembername$($s$)$ with the least apartments that he$/$she cleans.

Request $4$: For all corporate clients that were referred by other corporate clients and that are also

renting one or more apartments from us$,$ retrieve the name of the corporate client, the client$$s

industry, location, building id$,$ apartment number, and the name of the corporate client that

referred it$.$