문제 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 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE NOT CITY LIKE '[aeuio]%' AND NOT CITY LIKE '%[aeuio]'

문제 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 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE NOT CITY LIKE '[aeuio]%' OR NOT CITY LIKE '%[aeuio]'

문제 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 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE NOT CITY LIKE '%[aueio]' 문제는 모음으로 끝나지 않는 도시에서 중복되지 않게 도시이름을 조회하는 거라 그 전에 풀었던 거에서 % 위치만 변경하면 쉽게 풀 수 있었다.

문제 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 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE NOT CITY LIKE '[aieuo]%' 모음으로 시작하지 않는 조건으로 인해 WHERE 조건 뒤에 NOT 만 붙히면 된다.

문제 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 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '[aeiou]%' AND CITY LIKE '%[aeiou]'; 전 문제는 조건이 간단하여 그냥 일일히 작성하였지만 이번엔 조건으로 하나씩 만들기에는 25개를 만들어야하기 때문에 이번엔 정규표현식으로 해결을 해보았다.

문제 https://www.hackerrank.com/challenges/weather-observation-station-7/problem?isFullScreen=true Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com 풀이(MSSQL) 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' 이번 문제는 모음으로 끝나는 도시들의 이름을..

문제 https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com 풀이(MSSQL) 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%' 특히 MSSQL은 조회 조건에서 특정 문자를 찾기 위해 LIKE를..

문제 https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com 풀이(MSSQL) SELECT TOP 1 CITY, LEN(CITY) FROM STATION ORDER BY 2, 1; SELECT TOP 1 CITY, LEN(CITY) FROM STATION ORDER BY 2 DESC, 1; 해당문제..

문제 https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true Weather Observation Station 4 | HackerRank Find the number of duplicate CITY names in STATION. www.hackerrank.com 풀이(MSSQL) SELECT COUNT(CITY) - COUNT(DISTINCT CITY) FROM STATION 처음에는 문제에 대한 이해가 되지 않아서 생각을 깊게 해야했던 것 같지만 총 CITY 수에서 중복되지 않은 CITY의 개수를 빼면 해결되는 문제였다.