UGC NET CSE | January 2017 | Part 3 | Question: 11

Question

Consider the following relation:

Works(emp_name, company_name,salary)

Here,emp name is primary key.

Consider the following SQL query

Select emp name
From works T
where salary > (select avg(salary)
               from works S
               where  T. company name =
                      S. company name)

The above query is for following:

• A. Find the highest paid employee who earns more  than the average salary of all employees of his company.
• B. Find the highest paid employee who earns more  than the average salary of all  the employees of all the companies.
• C. Find all employees who earn more than the average salary of all employees all the companies.
• D. Find all employees who earn more than the average salary of all employees of their company.

Answer 1

Option C according to me

Answer 2

Inner loop finds the average of the salary of employees of their respective companies. Outer loop compares each employee with the average salary of employees of their companies. Hence option “C” is correct