Consider the following relational database schema:

employee$($employee$-$name, employee$-$id$,$ street, e$-$city$)$

works$($employee$-$id$,$ company$-$id$,$ salary$)$

company$($company$-$name, company$-$id$,$ c$-$city$)$

manages$($employee$-$id$,$ manager$-$id$)$

Specify the following queries on this database schema using the relational operators we discussed in class. Write your answers on a separate sheet of paper in the order that they are specified below.

$1.$ Retrieve the name and address of employees who work for First Bank Corporation.

$2.$ Retrieve the name, street address, and city of residence of all employees who work for Thrifty Industries and earn more than $$10,000$ per year.

$3.$ Retrieve the name of all employees who live in the same city as the company for which they work.

$4.$ Retrieve the name of all employees who live on the same street and in the same city as do their managers.

$5.$ Retrieve the name of all employees who do not work for First Bank Corporation.

$6.$ Retrieve the name of all employees who earn more than every employee of Small Bank Corporation.

$7.($Assume that companies may be located in several cities$)$ Retrieve all companies located in every city in which Thrifty Industries is located.

$8.$ For each company, find the average salary of employees working for that company.

$9.$ For each city, find the number of employees who work for at least one company in that city.