Hacker Rank SQL

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

Column Type
ID Integer
Name String
Marks Integer

Theย STUDENTS table is described as follows:

contains uppercase (Aโ€“Z) and lowercase (aโ€“z) letters.

Sample Input

ID Name Marks
1 Ashley 81
2 Samantha 75
3 Julia 76
4 Belvet 84

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.