Using SQL-Plus:

The tables required to get this information from is

Dept:

Employee:

5. Which department has more employees than Department 20? DEPTNAME Einance 6. Which employees have been working in the company longer than Larry Houston? ENAME LNAME John Smith 7. Find all employees in the Sales Department by using a nested query. ENAME LNAME Shaw Garner Jinku Stanley 8. Use a multiple-level subquery to display dependent information for employees who belong to the Finance department EMPLOYEEID DEPENDENTID DEPDOB RELATION 1 75-02-04 Spouse 2 97-08-23 Son 3 99-07-10 Daughter 1 45-12-12 Spouse 9. Display student Jose Diaz's faculty advisor's name and phone number. NAME PHO Mobley 529 10. Display all information regarding classrooms ROOMID BUILDIN ROO CAPACITY R 15 Nehru 301 16 Nehru 309 50 C 45 C