> > >

SQL MCQs

For a table with the following data:
Name Marks
John 400
Brown 200
Darwin 350
Kamy 250
Which of the following queries will give you names of all students having above average marks?

SELECT name FROM student WHERE marks > (SELECT AVG(marks) FROM student)

SELECT name FROM student WHERE marks > AVG(marks)

SELECT name FROM student WHERE marks > AVG(marks) GROUP BY marks

Answer

Correct Answer:

SELECT name FROM student WHERE marks > (SELECT AVG(marks) FROM student)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it