HackerRank SQL Solution - Basic Select - Weather Observation Station 6

• Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION.
• Your result cannot contain duplicates.

Input Format:

• The STATION table is described as follows:

HackerRank SQL Solution - Basic Select - Weather Observation Station 5

• Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.
• The STATION table is described as follows:

HackerRank SQL Solution - Basic Select - Weather Observation Station 4

• Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.
• The STATION table is described as follows:

HackerRank SQL Solution - Basic Select - Weather Observation Station 3

• Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.
• The STATION table is described as follows:

HackerRank SQL Solution - Basic Select - Weather Observation Station 1

• Query a list of CITY and STATE from the STATION table.
• The STATION table is described as follows:

HackerRank SQL Solution - Basic Select - Japanese Cities' Names

• Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
• The CITY table is described as follows:

HackerRank SQL Solution - Basic Select - Japanese Cities' Attributes

• Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
• The CITY table is described as follows:

HackerRank SQL Solution - Basic Select - Select By ID

• Query all columns for a city in CITY with ID 1661.
• The CITY table is described as follows: