Weather Observation Station 16 & Weather Observation Station 8 (hackerrank)

Weather Observation Station 16

https://www.hackerrank.com/challenges/weather-observation-station-16/problem?isFullScreen=true

SELECT MIN(ROUND(LAT_N,4))
FROM station
WHERE lat_n > 38.7780

Weather Observation Station 8

https://www.hackerrank.com/challenges/weather-observation-station-8/problem?isFullScreen=true

SELECT DISTINCT CITY
FROM STATION
WHERE LEFT(CITY,1) IN ('A', 'E', 'I', 'O', 'U') 
AND RIGHT(CITY,1) IN ('A', 'E', 'I', 'O', 'U')