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.
[My Answer]
select city, state from station
where LAT_N >0 and LONG_W > 0
Difficult points is Lat and Long.. it makes me using wiki...
'Code Problems > SQL_ HackerRank' 카테고리의 다른 글
[HackerRank] Weather Observation Station 4 (0) | 2021.04.11 |
---|---|
[HackerRank] Weather Observation Station 3 (0) | 2021.04.08 |
[HackerRank]Japanese Cities' Names (0) | 2021.04.08 |
[HackerRank]Select By ID (0) | 2021.04.08 |
[HackerRank]Revising the Select Query II (0) | 2021.03.30 |