75. more-than-75-marks

https://www.hackerrank.com/challenges/more-than-75-marks

SELECT name FROM students WHERE marks > 75 ORDER BY SUBSTRING(name,-3,3), id

[배운 점]

• SUBSTRING으로 자른 문자로 정렬하기

weather-observation-station-12

https://www.hackerrank.com/challenges/weather-observation-station-12/

SELECT DISTINCT CITY
FROM STATION
WHERE CITY REGEXP '^[^AEIOU].*[^aeiou]$';

[배운 점]

• REGEXP 정규식 활용하기

what-type-of-triangle

https://www.hackerrank.com/challenges/what-type-of-triangle

SELECT CASE
    WHEN A + B <= C THEN 'Not A Triangle'
    WHEN A = B and B = C THEN 'Equilateral'
    WHEN A = B or B = C or A = C THEN 'Isosceles'
    ELSE 'Scalene'
    END
 FROM TRIANGLES