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

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay