URL : https://www.hackerrank.com/challenges/30-hello-world/problem Objective In this challenge, we review some basic concepts that will get you started with this series. You...

Weather Observation Station 9 URL : https://www.hackerrank.com/challenges/weather-observation-station-9/problem Query the list of CITY names from STATION that do not start with vowels. Your r...

Weather Observation Station 8 URL : https://www.hackerrank.com/challenges/weather-observation-station-8/problem Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, ...

Weather Observation Station 7 URL : https://www.hackerrank.com/challenges/weather-observation-station-7/problem Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Y...

Weather Observation Station 6 URL : https://www.hackerrank.com/challenges/weather-observation-station-6/problem Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from...

Weather Observation Station 5 URL : https://www.hackerrank.com/challenges/weather-observation-station-5/problem Query the two cities in STATION with the shortest and longest CITY names, as we...

Weather Observation Station 4 URL : https://www.hackerrank.com/challenges/weather-observation-station-4/problem Find the difference between the total number of CITY entries in the table and t...

Weather Observation Station 3 URL : https://www.hackerrank.com/challenges/weather-observation-station-3/problem Query a list of CITY names from STATION for cities that have an even ID number....

Weather Observation Station 2 URL : https://www.hackerrank.com/challenges/weather-observation-station-2/problem Query the following two values from the STATION table: The sum of all values ...

Weather Observation Station 17 URL : https://www.hackerrank.com/challenges/weather-observation-station-17/problem Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT...