HackerRank[MySQL] : Higher Than 75 Marks

SOOYEON·2022년 7월 4일
0

SQL

목록 보기
43/54

Q

SELECT NAME
FROM STUDENTS
WHERE MARKS > 75
ORDER BY RIGHT(NAME,3), ID

SUBSTRING

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

0개의 댓글