Hackerrank
-
[HackerRank/Basic Select] Weather Observation Station 7공부/PS ( SQL) 2022. 5. 15. 23:21
https://www.hackerrank.com/challenges/weather-observation-station-7/problem Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. 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'
-
[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%'