# Higher Than 75 Marks Solution

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.