Sun. Jul 3rd, 2022

# Category: HackerRank Sql

#### Weather Observation Station 12 sql – Hacker Rank Solution

Problem Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is…

#### Revising Aggregations The Sum Function – Hacker Rank Solution

Problem Query the total population of all cities in CITY where District is California. Input Format The CITY table is described as follows:   Oracle Revising Aggregations The Sum Function – Hacker Rank Solution Disclaimer: The above Problem (Revising…

#### Revising Aggregations – Averages – Hacker Rank Solution

Problem Query the average population of all cities in CITY where District is California. Input Format The CITY table is described as follows:   Revising Aggregations Averages sql – Hacker Rank Solution Disclaimer: The above Problem (Revising Aggregations –…

#### Average Population – Hacker Rank Solution

Problem Query the average population for all cities in CITY, rounded down to the nearest integer. Input Format The CITY table is described as follows:   Average Population – Hacker Rank Solution Disclaimer: The above Problem (Average…

#### Japan Population sql – Hacker Rank Solution

Problem Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN. Input Format The CITY table is described as follows:   Japan Population – Hacker Rank Solution Disclaimer: The…

#### Japanese Cities’ Names query in SQL – Hacker Rank Solution

Problem 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: Japanese Cities’ Names query in SQL – Hacker Rank Solution Disclaimer: The above…

#### Weather Observation Station 1 query in SQL – Hacker Rank Solution

Problem Query a list of CITY and STATE from the STATION table.The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude Weather Observation Station 1 query in SQL – Hacker Rank Solution Disclaimer: The…

#### Weather Observation Station 3 query in SQL – Hacker Rank Solution

Problem 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: where LAT_N is the northern…

#### Top Earners sql – Hacker Rank Solution

Problem We define an employee’s total earnings to be their monthly  worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total…

#### Weather Observation Station 4 query in SQL – Hacker Rank Solution

Problem 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: where LAT_N is the northern latitude and LONG_W is the…

#### Weather Observation Station 5 in SQL – Hacker Rank Solution

Problem 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…

#### Weather Observation Station 2 sql – Hacker Rank Solution

Problem Query the following two values from the STATION table: The sum of all values in LAT_N rounded to a scale of 2 decimal places. The sum of all values in LONG_W rounded to a scale of 2 decimal places.…