The data inside the STUDENT relation is like:
What will be the resulting list for the following query:
SELECT STUDENT_FNAME
FROM STUDENT
ORDER BY MARKS_MATHS DESC, MARKS_PHYSICS ASC;
1
Nirav, Astha, Rohan, Anand, Raghav, Kartik, Vani, Avinash, Divya, Aditya
2
Aditya, Divya, Avinash, Vani, Kartik, Raghav, Anand, Rohan, Astha, Nirav
3
Aditya, Divya, Avinash, Kartik, Vani, Raghav, Anand, Rohan, Astha, Nirav
4
Nirav, Astha, Rohan, Anand, Raghav, Vani, Kartik, Avinash, Divya, Aditya
5
Question Not Attempted