Mrs. Kumar is using table STUDENTS with the following columns: RNO, ADMNO, NAME, AGGREGATE. She wants to display all information of students in descending order of name and within ascending order of aggregate. She wrote the following SQL query and she did not get the desired output.
SELECT * FROM STUDENTS ORDER BY NAME, AGGREGATE DESC;