==== Query Set ==1==
Schema:
Employee {Eid, Ename, Ecity, Esalary, Dno, SuperId}
Dept {Dnumber, Dname, DMgrId}
Dept_Loc {Dnumber, Location}
Project {Pnum, Pname, Location, Dnum}
Works_on {EmpId, Pno, DutyHour}
1. Find the name of all employees in research department
2. Find the Eid of all employees who work in project 'CMC'
3. Find the name of all departments from mumbai and kolkata
4. Get all projects which are controlled by any department from Kolkata
5. Find the name of all employees with their salaries who work in
departments managed by Mr. Virat Kohli
6. Find the name of all project and their controlling department names
and locations
7. Find the names of all projects where employee Rohit Sharma worked or
working for more than 100hours
8. Find the names of all employees with their supervisor's name
9. Find the names of all managers who do not play the role of a
supervisor
10. Find the names of all employees with their department names along
with the name the manager of that department
11. Get the name of all departments which do not controll any project
from Delhi
12. Get the name of all departments which do not contoll any project
where Mr. Rishav Pant working or worked
13. Find the name of all employees with their project names where they
worked
14. Find the name of all employees who earn more than 1500 and resides in
Kolkata but do not work in any department from Kolkata neither he/she
work in any project located in Kolkata
15. Find the name of all employees who works in some projects where Mr.
Ravi Shastri worked
-----------------------------------All the best--------------------------
Dept. of CSS, BWU 1