Korth Only Questions

--Exercise solve from Korth problem 4.2 ---------------------------------------------------------Schema declarations manages (employee_name, manager_name); company(company_name, city); works(employee_name, company_name,salary); employee(employee_name, street, city); Question A: Find the names of all employee who works for vsnl Question B: Find the name cities of residents of all employees who works for vsnl Question C: Find the names, street address, cities of residents of all employees who works for aol and earn more than 20000 Question D: Find all employees in the database who live in the same cities as the companies for which they work Question E: Find all the employee in the database who live in the same city and in the same street as do their managers. Question F: Find all the employee in the database who do not work for vsnl. Question G: Find all the employee in the database who earn more than every employee of the satyam. Question H: Assume that company may be located in saveral cities. Find all the companies located in every city in which vsnl is located. Question I: Find all the employee their company.

who earn more than the average salary of all employee of

Question J: Find the company that has most no. of employee. Question K: Find the company that has smallest payroll. Question L: Find those companies whose employee earn higher salary on avarage salary, than the avarage salary of satyam.