Query a list of CITY and STATE from the STATION table.
The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.
SELECT
CITY, STATE
FROM
STATION
WHERE
LAT_N > 0 AND LONG_W >0

'SQL > HackerRank' 카테고리의 다른 글
| [MySQL/HackerRank] Weather Observation Station 4 (0) | 2024.08.11 |
|---|---|
| [MySQL/HackerRank] Weather Observation Station 3 (0) | 2024.08.11 |
| [MySQL/HackerRank] Japanese Cities' Names (0) | 2024.08.11 |
| [MySQL/HackerRank] Select By ID (0) | 2024.08.11 |
| [MySQL/HackerRank] Select All (0) | 2024.08.11 |