The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT_Name). COnsider the following SQL Query:
SELECT DEPT_Name from STUDENT where SEX='M'
group by DEPT_Name having avg(Marks)>SELECT avg(Marks) from STUDENT
It returns the name of the department for which
- The average marks of Male students is more than the average marks of students in the department
- The average marks of Male students is more than the average marks of students in the university
- The average marks of students is more than the average marks of male students in the university
- The average marks of Male students is more than the average marks of male students in the university