Nice discussion. i have ever seen higher figure than 75 marks on Nova patti

Both the Names and IDs have to be sorted ascendingly. It specifies that for IDs but not for Names.

SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY RIGHT(NAME,3), ID ASC;

You can query students scoring above a certain mark with SELECT Name FROM STUDENTS WHERE Marks > Value ORDER BY RIGHT(Name, 3), ID ASC;. Like a No777 by type and color for easy selection, this query organizes student names by the last three characters and ID, making results clear and structured.

You can query students scoring above a certain mark with SELECT Name FROM STUDENTS WHERE Marks > Value ORDER BY RIGHT(Name, 3), ID ASC;. Like a hot chocolate price starbucks by type and color for easy selection, this query organizes student names by the last three characters and ID, making results clear and structured.