retagged by
460 views
3 votes
3 votes

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?

  1. Mean of the marks
  2. Median of the marks
  3. Mode of the marks
  4. Average of the marks
retagged by

Please log in or register to answer this question.

Answer:

Related questions

3 votes
3 votes
1 answer
4
Bikram asked Aug 26, 2017
393 views
What is the number of rows returned by an SQL query on the below EMP table?$\begin{array}{|c|c|c|} \hline \text{eno} & \text{ename} & \text{manager} \\ \hline 1 & A & \te...