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$.$ 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$.$ Please please please. Thank you.