A description of the problem can be found on Hackerrank.
I created solution in:
All solutions are also available on my GitHub.
select name from
select name, substr(name, length(name)-2) as sub_name
where marks > 75 order by sub_name, id asc