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

Question

Consider the following schema and answer the following SQL queries
Employee (employee-name, street, city)
works (employee-name, company-name, salary)
company (company-name, city)
manages (employee-name, manger-name)

i)Find he names, street, city of all employees who works for ‘Infosys’ & earn more than $50,000)

ii)Find the name of all employees in the database who live in the same cities as the companies for which they work.

iii) Find the name of the all employees in the database who do not work for ‘Infosys’.

iv) Find the names of all employees in tha database who earn more than every employee of “TCS”.

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