Weather Observation Station 1
Last updated
Last updated
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.
Sol:
SELECT CITY, STATE FROM STATION;
Explanation:
SELECT CITY, STATE: This part of the query indicates that we want to retrieve the values in the CITY and STATE columns of the STATION table.
FROM STATION: This specifies the table from which we want to retrieve the data, which is the STATION table.
