Comprehension Passage
Consider the following student relation.
Student relation has Name, Subject1_Marks, and Subject2_Marks attributes.
| Name | Subject1_Marks | Subject2_Marks |
| A | 10 | 5 |
| B | Null | 10 |
| C | 20 | 15 |
| D | Null | 20 |
| E | 30 | Null |
| F | Null | 25 |
What is the output for the given SQL query?
Query:
Select name, max(subject1_Marks)
From student;
Which of the following option is true?
1
Prints name of the student and his maximum marks.
2
Prints the student maximum marks.
3
Prints error
4
Prints the name of the who has maximum marks
5
None of the above