SELECT BName
FROM PROF
WHERE sex = ‘M’
GROUP BY BName
HAVING avg(salary) > (SELECT avg(salary)
FROM PROF)
Consider the above query with relation PROF(PName, sex, salary, BName).
What will be the result of the above query ?
1
Name of the professors whose average salary is more than average salary of all professors.
2
Name of the branches in which average salary of the male professors is more than average salary of all professors.
3
Name of male professors whose average salary is more than average salary of all professors.
4
None of these
5
Question Not Attempted