Consider the table given below:
Table : STUDENT
| ADMNO | NAME | CLASS | SCORE |
| A001 | Amit | 12A | 90 |
| A002 | Amit | 12B | 91 |
| A003 | Bhavana | 12A | 90 |
| A004 | Yamini | 12A | 89 |
| A005 | Ashok | 12B | 95 |
Which of the following command will display all the records according to their names in descending order and their scores in descending order?
1
SELECT * FROM STUDENT ORDER BY NAME, SCORE DESC;
2
SELECT * FROM STUDENT ORDER BY NAME AND SCORE DESC;
3
SELECT * FROM STUDENT ORDER BY NAME DESC, SCORE DESC;
4
SELECT * FROM STUDENT ORDER BY NAME DESC AND SCORE DESC;