📌 Weather Observation Station 12 문제 더보기 https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com 문제 해석 STATION 테이블에서 모음(a, e, i, o, u)로 시작하지 않고 끝나지 않는 CITY 리스트를 쿼리하라. 중복 제거. 정답 SELECT DISTINCT CITY FROM STATIO..
📌 Weather Observation Station 11 문제 더보기 https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com 문제 해석 STATION 테이블에서 모음(a, e, i, o, u)로 시작하지 않거나 끝나지 않는 CITY 리스트를 쿼리하라. 중복 제거. 정답 SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY..
📌 Weather Observation Station 10 문제 더보기 https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com 문제 해석 STATION 테이블에서 모음(a, e, i, o, u)로 끝나지 않는 CITY 리스트를 쿼리하라. 중복 제거. 정답 SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY, '[^A,E,I,O,U]$'); 다른 ..
📌 Weather Observation Station 9 문제 더보기 https://www.hackerrank.com/challenges/weather-observation-station-9/problem?isFullScreen=true Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com 문제 해석 STATION 테이블에서 모음(a, e, i, o, u)로 시작하지 않는 CITY 리스트를 쿼리하라. 중복 제거. 정답 SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(C..
📌 Weather Observation Station 8 문제 더보기 https://www.hackerrank.com/challenges/weather-observation-station-8/problem?isFullScreen=true Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com 문제 해석 STATION 테이블에서 처음 및 마지막 문자가 모음(a, e, i, o, u)이 들어가는 CITY 이름 목록을 쿼리하라. 중복 제거. 정답 SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY, '^[aeiou]',..
