[SQL Problem]Higher Than 75 Marks

SELECT NAME
FROM STUDENTS
WHERE Marks > 75 
ORDER BY RIGHT(NAME, 3) , ID

Syntax

LEFT(string, number_of_chars)

REF: https://docs.microsoft.com/en-us/sql/t-sql/functions/left-transact-sql?view=sql-server-ver15