HackerRank SQL Solution - Basic Select - Weather Observation Station 7

  • Query the list of CITY names ending with vowels (a, e, i, o, 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 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:

You might also like

Deploy your Django web app to Azure Web App using App Service - F1 free plan

In this post, we will look at how we can deploy our Django app using the Microsoft Azure app service - a free plan. You need an Azure accoun...