cs

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

https://www.hackerrank.com/challenges/weather-observation-station-1/problem

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...

+ Recent posts