Sql Question Employee Employeeid Employee Name Street City Works Employeeid Company Name S Q37210305

SQL question

Employee(employeeID, employee-name, street, city)

Works(employeeID, company-name, salary)

Company(company-name, city)

Manages(employeeID, managerID)

Write the following Queries:

1.1 Find the names, street address, and cities of residence forall employees who work for ‘First Bank Corporation’ and earn morethan $10,000.

1.2 Find the names of all employees in the database who live inthe same cities as the companies for which they work

1.3 Find the names of all employees in the database who live inthe same cities and on the same streets as do their managers

1.4   Find the names of all employees in the databasewho do not work for ‘First BankCorporation’. Assume that all peoplework for exactly one company

Answer

1.1

SELECT

OR

 

OR