[HackerRank Solutions] [SQL] Basic Select – Weather Observation Station 1

Query a list of CITY and STATE from STATION.

Input Format

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.


Solution

Note:

  • Solusi-solusi dari challenge yang diberikan HackerRank murni berasal dari penulis sendiri.

 

Pada challenge di atas, kita diminta untuk membuat query untuk menampilkan daftar City dan State dari table STATION.

Erik Gunawan

Java Developer, Android Developer, Microsoft Office Specialist, Pengamat One Piece, Blogger, Mahasiswa

Erik Gunawan

Java Developer, Android Developer, Microsoft Office Specialist, Pengamat One Piece, Blogger, Mahasiswa

Leave a Reply

Your email address will not be published. Required fields are marked *

wp-puzzle.com logo