DEV Community

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

Posted on

2

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)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more