728x90
반응형
문제 : Query a list of CITY names from STATION with even ID numbers only. You may print the results in any order, but must exclude duplicates from your answer.
select distinct CITY
from STATION
where MOD(ID,2) = 0;
728x90
반응형
'DB > SQL' 카테고리의 다른 글
HackerRank_11. Weather Observation Station 5 (0) | 2020.06.11 |
---|---|
HackerRank_10. Weather Observation Station 4 (0) | 2020.06.11 |
HackerRank_08. Weather Observation Station 2 (0) | 2020.06.11 |
HackerRank_07.Weather Observation Station 1 (0) | 2020.06.11 |
HackerRank_06. Japanese Cities' Names (0) | 2020.06.11 |