Hello Friends in this article i am gone to share Hacker Rank SQL Solutions with you | Higher Than 75 Marks Solution

Also Visit:  Weather Observation Station 12 Solution

Problem

Query the Name of any student in STUDENTS who scored higher than 75 Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.

Input Format

The STUDENTS table is described as follows:

contains uppercase (A–Z) and lowercase (a–z) letters.

Sample Input

Sample Output

Ashley
Julia
Belvet

Explanation

Only Ashley, Julia, and Belvet have Marks > 75. If you look at the last three characters of each of their names, there are no duplicates and ‘ley’ < ‘lia’ < ‘vet’.

Solution – Higher Than 75 Marks

MySQL Code

SELECT name FROM students 
WHERE marks > 75 ORDER BY SUBSTR(name, LENGTH(name)-2, 3), id;

Logic:

Use SBUSTR(,decimal places) for the last three characters, and since it is the “last”, the decimal places would be negative here

Solution:

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

Disclaimer: The above Problems are generated by Hacker Rank but the Solutions are Provided by NYANDER.COM. All Hacker Rank SQL Solutions Shared only for Educational and Learning Purpose.