DEV Community

Cover image for HackerRank SQL Preparation: Weather Observation Station 1(MySQL)
Christian Paez
Christian Paez

Posted on

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;

Enter fullscreen mode Exit fullscreen mode

Explanation:

  • SELECT CITY, STATE: This part of the query specifies that you want to retrieve the CITY and STATE columns from the STATION table.
  • FROM STATION: Indicates that you are selecting data from the STATION table.

Top comments (0)