-
[HackerRank/Basic Select] Weather Observation Station 6공부/PS ( SQL) 2022. 5. 15. 23:18
https://www.hackerrank.com/challenges/weather-observation-station-6/problem
Weather Observation Station 6 | HackerRank
Query a list of CITY names beginning with vowels (a, e, i, o, u).
www.hackerrank.com
문제
풀이
SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE 'a%' OR CITY LIKE 'e%' OR CITY LIKE 'i%' OR CITY LIKE 'o%' OR CITY LIKE 'u%'
'공부 > PS ( SQL)' 카테고리의 다른 글
[HackerRank/Basic Select] Weather Observation Station 8 (0) 2022.05.15 [HackerRank/Basic Select] Weather Observation Station 7 (0) 2022.05.15 [HackerRank/Basic Select] Weather Observation Station 5 (0) 2022.05.15 [HackerRank/Basic Select] Weather Observation Station 4 (0) 2022.05.15 w3schools - sql exercise (1) (0) 2021.11.30