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.
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.