Question: Let consider the given tables:
Works (Pname, Cname, Salary)
Lives (Pname, Street, City)
Locatedin (Cname, City)
Manager (Pname, Mgrname)
Where Pname = Person name, Cname = Company name, Mgrname = Manager name
Write down the SQL for the given:
A) List all the names of people who work for the company Wipro all along with the cities they live in.
B) List all the names of people, all along with the streets and city addresses, who work for the company "Infosys" with salary greater than Rs. 50000.
C) List all the names of persons who live and work in the similar city.
D) List all the names of person who don’t work for ‘Infosys’.
E) List all the persons whose salaries are greater than that of the entire Oracle employee.
F) List all the names of companies which are situated in every city where the company ‘Infosys’ is situated.