Problem Statement:
Query a list of CITY and STATE from the STATION table.
Link: HackerRank - Weather Observation Station 1
Solution:
SELECT CITY, STATE FROM STATION;
Explanation:
-
SELECT CITY, STATE
: This part of the query specifies that you want to retrieve theCITY
andSTATE
columns from the STATION table. -
FROM STATION
: Indicates that you are selecting data from the STATION table.
Top comments (0)