Answer to Question #145160 in Databases | SQL | Oracle | MS Access for Ankita Sonawane

Question

Consider the following schema and answer the following SQL queries.
Employee ( person_name , street, city)
Works (person_name, company_name, salary) Company (company_name, city )
Manages (person_name , manager_name)

i) Find name and cities of residence of all employees who work for Wipro.

ii) Find the name of all employees in this database who live in the same city as the company for which they work.

iii) Find the name of all employees in this database who do not work for Wipro.

iv) Find the name street address and cities of all employees who work for Wipro and earn more than Rs. 10000

Answer 1

Dear Ankita Sonawane, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order