oracle -- select name from students where marks>75 order by substr(name,-3,3), id asc;

what is substr....? does sql have predefined functions...... if sql have predefined functions what are they? and how many of them?

SQL SERVER

select name from students where marks > 75 order by RIGHT(NAME,3), id asc

PL/SQL, MySQL, SQL

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

--RIGHT() https://stackoverflow.com/questions/17409605/how-can-i-use-left-right-functions-in-sql-to-get-last-3-characters

MySQL:

SELECT NAME FROM STUDENTS WHERE 1=1 AND MARKS>75 ORDER SUBSTR(NAME,-3),ID ASC;