id name title emp_id
0008 Jeff VP 0004
1001 Mark Manager 0008
1002 John Manager 0008
1003 vis P/A 1001
1004 Mary Sr. P/A 1001
1005 Rob DA 1002
1006 son DBA 1001
1007 Will SA 1002


(1) Write a query to find employee id for all employees who have more than 10 people directly report to him/her.

(2) Write a query to list all columns for employees who has more than 20 people directly report to him/her

(3) Write a query to find id, name,
emp_id, name for all employees
whose supervier’s job title is ‘Manager’

(4) Assume the EMPLOYEES table has more then 50,000,000 records, and the only index in this table is emp_id. Write a query to find emp_id for all employees who do not have any one work under him/her. Please consider the efficiency.


Please try to answer me ASAP

Thanks in advance.

Praveen


[Edited by admala on 12-20-2000 at 07:50 PM]