본문 바로가기

regexp

[HackerRank][SQL] Weather Observation Station 12 - 컴도리돌이 Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com Problem Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates. -> 도시 이름의 시작과 끝이 모음이 포함하지 않는 도시의 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where ci.. 더보기
[HackerRank][SQL] Weather Observation Station 10 - 컴도리돌이 Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com Problem Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. -> 모음으로 끝나지 않는 도시 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where city regexp "[^aeiou]$" 더보기
[HackerRank][SQL] Weather Observation Station 9 - 컴도리돌이 Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com Problem Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. -> 모음으로 시작하지 않는 도시 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where city regexp "^[^aeiou]" 더보기
[HackerRank][SQL] Weather Observation Station 8 - 컴도리돌이 Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com Problem Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. -> station에서 처음과 마지막 문자로 모두 모음이 있는 CITY 이름 목록을 중복 없이 출력하시오. Answer select distinct(city) from station where city .. 더보기
[HackerRank][SQL] Weather Observation Station 7 - 컴도리돌이 Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com Problem Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. -> station에서 모음(a, e, i, o, u)으로 끝나는 CITY 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where city regexp "[aeiou]$" 더보기
[HackerRank][SQL] Weather Observation Station 6 - 컴도리돌이 Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com Problem Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. -> station에서 모음(예: a, e, i, o, u)으로 시작하는 city를 중복 없이 출력하시오. Answer select distinct(city) from station where city regexp "^[aeiou]" -- .. 더보기

티스토리툴바