Monday 23 November 2015

Q8,p-3,j15.The student information in a university is 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 department for which:
Options
A)The average marks of male students is more than the average marks of the same department.
B)The average marks of male students is more than the average marks of students in the university.
C)The average marks of male students is more than the average marks of male students in university.
d) The average marks of students is more than the average marks of male students in the university.
Answer B.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.