Hackerrank – Weather Observation Station 5

Problem Statement A description of the problem can be found on Hackerrank. Solution 2 queries: One that selects cities that are ordered by city length ascending and printed first row containing city and its length. Second is almost the same as first but cities are ordered descending. In both queries I used second ordering by […]

Hackerrank – Weather Observation Station 6

Problem Statement A description of the problem can be found on Hackerrank. Solution Check if city starts with one of (‘a’, ‘i’, ‘e’, ‘o’, ‘u’) and orders them alphabetically. I created solution in: SQL All solutions are also available on my GitHub. SQL

Hackerrank – Weather Observation Station 7

Problem Statement A description of the problem can be found on Hackerrank. Solution Almost the same principle as Weather Observation Station 6, only substring is different. I created solution in: SQL All solutions are also available on my GitHub. SQL

Hackerrank – Weather Observation Station 8

Problem Statement A description of the problem can be found on Hackerrank. Solution Joins conditions of Weather Observation Station 6 and Weather Observation Station 7 I created solution in: SQL All solutions are also available on my GitHub. SQL

Hackerrank – Weather Observation Station 9

Problem Statement A description of the problem can be found on Hackerrank. Solution As Weather Observation Station 6, only the condition is opposite. I created solution in: SQL All solutions are also available on my GitHub. SQL

Hackerrank – Weather Observation Station 10

Problem Statement A description of the problem can be found on Hackerrank. Solution As Weather Observation Station 7, only the condition is opposite. I created solution in: SQL All solutions are also available on my GitHub. SQL

Hackerrank – Weather Observation Station 11

Problem Statement A description of the problem can be found on Hackerrank. Solution As Weather Observation Station 8, only the condition is opposite. I created solution in: SQL All solutions are also available on my GitHub. SQL

Hackerrank – Weather Observation Station 12

Problem Statement A description of the problem can be found on Hackerrank. Solution Only difference between Weather Observation Station 11 is ‘AND’. I created solution in: SQL All solutions are also available on my GitHub. SQL

Hackerrank – Higher Than 75 Marks

Problem Statement A description of the problem can be found on Hackerrank. Solution I created solution in: SQL All solutions are also available on my GitHub. SQL

Hackerrank – Japanese Cities’ Detail

Problem Statement A description of the problem can be found on Hackerrank. Solution Select all columns and filter if CoutryCode equals ‘JPN’. I created solution in: SQL All solutions are also available on my GitHub. SQL