Weather Observation2 - SQL

 Weather Observation 시리즈 SQL 문제 풀이 2

 

Weather Observation Station 11

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

Weather Observation Station 11 | HackerRank

SELECT DISTINCT city
FROM station
WHERE city REGEXP '^[^aeiou]|[^aeiou]$'

---

 

Weather Observation Station 12

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

Weather Observation Station 12 | HackerRank

SELECT DISTINCT city
FROM station
WHERE city NOT LIKE 'a%'
AND city NOT LIKE 'e%'
AND city NOT LIKE 'i%'
AND city NOT LIKE 'o%'
AND city NOT LIKE 'u%'
AND city NOT LIKE '%e'
AND city NOT LIKE '%i'
AND city NOT LIKE '%o'
AND city NOT LIKE '%u'
AND city NOT LIKE '%a'

---

 

Weather Observation Station 13

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

Weather Observation Station 13 | HackerRank

SELECT TRUNCATE(SUM(LAT_N), 4)
FROM station
WHERE LAT_N BETWEEN 38.7880 AND 137.2345

---

Weather Observation Station 14

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

Weather Observation Station 14 | HackerRank

SELECT TRUNCATE(MAX(LAT_N), 4)
FROM station
WHERE LAT_N < 137.2345

---

 

Weather Observation Station 15

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

Weather Observation Station 15 | HackerRank

SELECT ROUND(LONG_W,4)
FROM station
WHERE LAT_N < 137.2345
ORDER BY LAT_N DESC
LIMIT 1

---

 

 

Weather Observation Station 16

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

Weather Observation Station 16 | HackerRank

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

---

Weather Observation Station 17

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

Weather Observation Station 17 | HackerRank

SELECT ROUND(LONG_W, 4)
FROM station
WHERE LAT_N > 38.7780
ORDER BY LAT_N
LIMIT 1;

---

 

Weather Observation Station 18

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

Weather Observation Station 18 | HackerRank

SELECT ROUND(ABS(MIN(lat_n)-MAX(lat_n))+  
        ABS(MIN(long_w)-MAX(long_w)), 4)
FROM station

---

Weather Observation Station 19

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

Weather Observation Station 19 | HackerRank

SELECT ROUND(SQRT(POWER(MAX(LAT_N)  - MIN(LAT_N),  2)
      + POWER(MAX(LONG_W) - MIN(LONG_W), 2)), 4)
FROM station