![HackerRank SQL Preparation: Weather Observation Station 1(MySQL)](https://res-3.cloudinary.com/hbig9cpoo/image/upload/q_auto/v1/ghost-blog-images/Sin-t-tulo-1-3-.png)
HackerRank SQL Preparation: Weather Observation Station 1(MySQL)
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.