CODE EXAMPLE FOR SQL

get last three characters in mysql column

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