Weather Observation Station 1

- Weather Observation Station 1

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;

Expected Output

```
Acme LA 
```
```
Addison MI 
```
```
Agency MO 
```
```
Aguanga CA 
```
```
Alanson MI 
```
```
Alba MI 
```
```
Albany CA 
```
```
Albion IN 
```
```
Algonac MI 
```
```
Aliso Viejo CA 
```
```
Allerton IA 
```
```
Alpine AR 
```
```
Alton MO 
```
```
Amazonia MO 
```
```
Amo IN 
```
```
Andersonville GA 
```
```
Andover CT 
```
```
Anthony KS 
```
```
Archie MO 
```
```
Arispe IA {-truncated-}
```

Tags hackerrank_sql_easy

Post a Comment