Tuesday, April 5, 2016

Query a list of CITY and STATE from STATION.(WEATHER OBSERVATION STATION1)

Query a list of CITY and STATE from STATION.
Input Format
The STATION table is described as follows:
where LAT_N is the northern latitude and LONG_W is the western longitude.

SOLUTION:

           SELECT CITY,STATE from STATION;


Explanation:

    The question is that we have been asked to write a query that lists the CITY and STATION fields present in the table STATION.