Skip to main content

Command Palette

Search for a command to run...

HackerRank: Weather Observation Station 1

Published
1 min read

Question and Answer:

Key Points:

What the Query Does

  • Retrieves the CITY and STATE fields for every row in the STATION table

Key SELECT Fields

  • Only CITY and STATE are requested (not other columns)

Why It Works

  • No WHERE condition → returns all stations

  • Meets requirement: “Query a list of CITY and STATE”