Hello coders, In this post, you will learn how to solve the Weather Observation Station 1 query in SQL Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.

Problem
Query a list of CITY and STATE from the STATION table.
The STATION table is described as follows:
where LAT_N is the northern latitude and LONG_W is the western longitude
Weather Observation Station 1 query in SQL Hacker Rank Solution
SELECT CITY,STATE FROM STATION;
Disclaimer: The above Problem (Weather Observation Station 1 query in SQL ) generated by Hackerrank but the Solution is Provided by Chase2Learn. This tutorial is only for Educational and Learning purposes.