SQL_Basic_Select_3
質問元HACKER RANK
問題の著作権はハッカーランキングにある.
問題の著作権はハッカーランキングにある.
-- Weather Observation Station 6
-- 'a','e','i','o','u'로 시작하는 도시 찾기
SELECT DISTINCT CITY FROM STATION
WHERE LEFT(CITY,1) IN ('a','e','i','o','u');
-- Weather Observation Station 7
-- 'a','e','i','o','u'로 끝나는 도시 찾기
SELECT DISTINCT CITY FROM STATION
WHERE RIGHT(CITY,1) IN ('a','e','i','o','u');
-- Weather Observation Station 8
-- 'a','e','i','o','u'로 시작하거나 끝나는 도시 찾기
SELECT DISTINCT CITY FROM STATION
WHERE LEFT(CITY,1) IN ('a','e','i','o','u')
AND RIGHT(CITY,1) IN ('a','e','i','o','u');
-- Weather Observation Station 9
-- 모음으로 시작하지 않는 도시 찾기
SELECT DISTINCT CITY FROM STATION
WHERE LEFT(CITY,1) NOT IN ('a','e','i','o','u');
-- Weather Observation Station 10
-- 'a','e','i','o','u'로 끝나지 않는 도시 찾기
SELECT DISTINCT CITY FROM STATION
WHERE RIGHT(CITY,1) NOT IN ('a','e','i','o','u');
-- Weather Observation Station 11
-- 'a','e','i','o','u'로 시작하지 않거나 끝나지 않는 도시 찾기
SELECT DISTINCT CITY FROM STATION
WHERE LEFT(CITY,1) NOT IN ('a','e','i','o','u')
OR RIGHT(CITY,1) NOT IN ('a','e','i','o','u');
-- Weather Observation Station 12
-- 'a','e','i','o','u'로 시작하지 않고, 끝나지 않는 도시 찾기
SELECT DISTINCT CITY FROM STATION
WHERE LEFT(CITY,1) NOT IN ('a','e','i','o','u')
AND RIGHT(CITY,1) NOT IN ('a','e','i','o','u');
Reference
この問題について(SQL_Basic_Select_3), 我々は、より多くの情報をここで見つけました https://velog.io/@wltn39/BasicSelect3テキストは自由に共有またはコピーできます。ただし、このドキュメントのURLは参考URLとして残しておいてください。
Collection and Share based on the CC Protocol