Hackerrank – Higher Than 75 Marks

Problem Statement
A description of the problem can be found on Hackerrank.

Solution

I created solution in:

All solutions are also available on my GitHub.

SQL

select name from 
(
    select name, substr(name, length(name)-2) as sub_name 
    from Students
    where marks > 75 order by sub_name, id asc
);

select name from

(

select name, substr(name, length(name)-2) as sub_name

from Students

where marks > 75 order by sub_name, id asc

);