HackerRank: Weather Observation Station 1
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”