~고군분투 인생살이~

[Easy] Weather Observation Station 3 본문

SQL/HACKER_RANK

[Easy] Weather Observation Station 3

소금깨 2022. 10. 24. 00:53

 

 

Weather Observation Station 3 | HackerRank

Query a list of unique CITY names with even ID numbers.

www.hackerrank.com

문제 조건

Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.

 

문제 풀이

SELECT DISTINCT city
FROM STATION
WHERE (ID % 2 ) = 0
저작자표시

'SQL > HACKER_RANK' 카테고리의 다른 글

[Medium] Weather Observation Station 19  (0) 2022.10.24
[Easy] Weather Observation Station 4  (0) 2022.10.24
[EASY] Weather Observation Station 1  (0) 2022.10.24
[MEDIUM] Weather Observation Station 18  (0) 2022.10.13
[MEDIUN] New Companies  (0) 2022.10.13
'SQL/HACKER_RANK' Related Articles more
Comments