## Hackerrank – Japanese Cities’ Name

Problem Statement A description of the problem can be found on Hackerrank. Solution Select only Names and filter by CountryCode equals to ‘JPN’. I created solution in: SQL All solutions are also available on my GitHub. SQL

## Hackerrank – Revising the Select Query – 2

Problem Statement A description of the problem can be found on Hackerrank. Solution The difference between Revising the Select Query – 1 is that you select only name column and filter by same conditions, only the population number is higher. I created solution in: SQL All solutions are also available on my GitHub. SQL

## Hackerrank – Revising the Select Query – 1

Problem Statement A description of the problem can be found on Hackerrank. Solution Select all columns and filter by CountryCode and Population. I created solution in: SQL All solutions are also available on my GitHub. SQL

## Hackerrank – Select All

Problem Statement A description of the problem can be found on Hackerrank. Solution Simple. Just select all rows and columns. I created solution in: SQL All solutions are also available on my GitHub. SQL

## Hackerrank – Select by ID

Problem Statement A description of the problem can be found on Hackerrank. Solution Select all rows and filter by value if ID column equals to 1661. I created solution in: SQL All solutions are also available on my GitHub. SQL

## Hackerrank – Weather Observation Station 1

Problem Statement A description of the problem can be found on Hackerrank. Solution Select City, State and then order first by city ascending and then state ascending. I created solution in: SQL All solutions are also available on my GitHub. SQL

## Hackerrank – Weather Observation Station 3

Problem Statement A description of the problem can be found on Hackerrank. Solution Select cities then filter if ID modulo 2 equals to 0 and order alphabetically ascending. I created solution in: SQL All solutions are also available on my GitHub. SQL

## Hackerrank – Weather Observation Station 4

Problem Statement A description of the problem can be found on Hackerrank. Solution In a subselect selects count of all cities and unique cities and then substract these numbers. I created solution in: SQL All solutions are also available on my GitHub. SQL