Multiple choice

What would be the SQL query/queries to list the regno of examinees who have a score greater than the average score? Table: Examinee(regno,name,score) Where regno is primary key.

  1. Select regno from examine where score>avg(score);

  2. Select regno, avg(score) from examine where score>avg(score);

  3. Select regno from examine where score>(select avg(score) from examinee);

  4. All of the above

  5. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Option 3 is the correct answer as avg(score) is used in select statement. The subquery is used to get the average score.

Keep practicing — related questions