[HackerRank SQL] Weather Observation Station 5, 6(MySQL)

www.hackerrank.com/challenges/weather-observation-station-5/problem

Weather Observation Station 5 | HackerRank

Answer

select city, length(city)
from station 
order by length(city), city
limit 1;

select city, length(city)
from station 
order by length(city) desc, city
limit 1;

 

---

www.hackerrank.com/challenges/weather-observation-station-6/problem

Weather Observation Station 6 | HackerRank

select city
from station
where city regexp '^[aeiou]' 

정규표현식을 사용한다.

MySQL에서 정규표현식은 regexp이다.