https://www.hackerrank.com/challenges/weather-observation-station-3/problem
Weather Observation Station 3 | HackerRank
Query a list of unique CITY names with even ID numbers.
www.hackerrank.com
SELECT DISTINCT CITY
FROM STATION
WHERE ID % 2 = 0;
'Algorithm > SQL' 카테고리의 다른 글
| [SQL][HackerRank] Weather Observation Station 5 (0) | 2020.06.08 |
|---|---|
| [SQL][HackerRank] Weather Observation Station 4 (0) | 2020.06.08 |
| [SQL][HackerRank] Weather Observation Station 1 (0) | 2020.06.08 |
| [SQL][HackerRank] Japanese Cities' Names (0) | 2020.06.08 |
| [SQL][HackerRank] Japanese Cities' Attributes (0) | 2020.06.08 |
