Consider the following tables:
WORKS(Pname, Cname, Salary)
LIVES(Pname, Street, City)
LOCATED(Cname, City)
MANAGER(Pname, Mname)
Write a query in SQL for the following:
(i) List the names of the people who work for the company Wipro' along with the cities they live in.
(ii) Find the people who work for the company `Infosys' having salary greater than 50,000.
(iii) List the names of the people, along with the street and city addresses.
(iv) Find the persons whose salaries are more than that of all of the 'Oracle' employees.
(v) Find the names of the persons who do not work in `Infosys'.
Make suitable assumptions, if any
Assumption: For the purpose of these queries, I'll assume that the columns `Pname` in the tables `WORKS`, `LIVES`, and `MANAGER` refer to the person's name, `Cname` in the tables `WORKS` and `LOCATED` refer to the company name, and `Mname` in the `MANAGER` table refers to the manager's name.
________ ________ ______ ______ ________ __________ ______ ____.__________ _______ ___ ___ _______ ____.
___ ____ ____ ____ __________ ______ __________ __________.
_______ ________ ___ __________ ___ ____ ____ _____ _________ ____ _____.
__________ _________ _____ __________ _____ ______ _____ _________ ____ ___.
________ _______ _________ ___ ___ ___.
___ ____ _____ ____ _____ _____ _______ _______ ____ __________ _____.
_______ _______ _____ _____ _____ ____.
__________ _______ _______ ______ _________ ___ _________.
___ ________ ________ ___ _________ _________ ___ __________ _______.
_____ __________ ______ _______ ______.
_________ ___ _____ _________ _______.
___ __________ _____ _____ ___ _______ _____ ______ ___ ________ _____ _______.
___ _________ ___ ______ ____ __________ _____ ________.
_______ ___ ____ ___ _________ __________ _______ ______ __________ _________ __________ ___.
_______ ____ ____ _____ ____ _______ ___ ____ _________ ________.
_______ _______ __________ _____ ______ _____ __________ ________ _________.
_________ _______ _________ ______ _______ ________ ____.
_________ _____ ________ ______ _______ _________ __________.
______ ______ _____ ______ ________ ________ __________ _____ _____ ___.
_______ ____ ____ _________ ___.
________ _________ _________ ________ ____ ___ _______.
_______ _________ __________ __________ _______ ____ ___ _____ ______ __________ ________ _____.
___.
Get Full Answer on WhatsApp