Consider the relation:
Exam(eid, marks)
Assume that marks take not null integers only. Also, marks takes distinct values and the number of tuples are odd.
Select marks from Exam E where (select Count(*) from Exam
where marks < E.marks ) = (select Count(*) from Exam where marks > E.marks)
What does the above SQL query print?
- Mean of the marks
- Median of the marks
- Mode of the marks
- Average of the marks