Hello coders, today we are going to solve Weather Observation Station 1 HackerRank Solution in SQL.
Problem
Query a list of CITY and STATE from the STATION table.
The STATION table is described as follows:
STATION
Field | Type |
ID | NUMBER |
CITY | VARCHAR2(21) |
STATE | VARCHAR2(2) |
LAT_N | NUMBER |
LONG_W | NUMBER |
where LAT_N is the northern latitude and LONG_W is the western longitude.
Solution – Weather Observation Station 1 in SQL
SELECT CITY, STATE FROM STATION;
Disclaimer: The above Problem (Weather Observation Station 1) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.