728x90
반응형
https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true
문제
Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.
Input Format
The STATION table is described as follows:
Code
SELECT DISTINCT CITY
FROM STATION
WHERE LEFT(CITY, 1) IN ('A', 'E', 'I', 'O', 'U');
728x90
반응형
'SQL > MySQL' 카테고리의 다른 글
[MySQL/HackerRank] Weather Observation Station 8 (0) | 2023.08.18 |
---|---|
[MySQL/HackerRank] Weather Observation Station 7 (0) | 2023.08.18 |
[MySQL/HackerRank] Weather Observation Station 4 (0) | 2023.08.12 |
[MySQL/HackerRank] Weather Observation Station 3 (0) | 2023.08.12 |
[MySQL/HackerRank] Weather Observation Station 1 (0) | 2023.08.12 |