## The Blunder SQL- Hacker Rank Solution

Problem Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard’s  key was broken until after completing the calculation. She wants … Read More

## Draw The Triangle 1 SQL – Hacker Rank Solution

Problem P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): Write a query to print the pattern P(20). Draw The Triangle 1 – Hacker Rank Solution Disclaimer: The above Problem (Draw … Read More

## Draw The Triangle 2 – Hacker Rank Solution

Problem P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): Write a query to print the pattern P(20). Draw The Triangle 2 – Hacker Rank Solution Disclaimer: The above Problem (Draw … Read More

## Print Prime Numbers SQL – Hacker Rank Solution

Problem Write a query to print all prime numbers less than or equal to 1000. Print your result on a single line, and use the ampersand (&) character as your separator (instead of … Read More

## Population Density Difference SQl- Hacker Rank Solution

Problem Query the difference between the maximum and minimum populations in CITY. Input Format The CITY table is described as follows:  Population Density Difference – Hacker Rank Solution Disclaimer: The above Problem (Population Density Difference) … Read More

## Japanese City’s Attributes query in SQL – Hacker Rank Solution

Problem Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. Input Format The CITY table is described as follows: Japanese City’s Attributes query in SQL – Hacker Rank Solution … Read More

## Select By ID query in SQL – Hacker Rank Solution

Problem Query all columns for a city in CITY with the ID1661. Input Format The CITY table is described as follows: Select By ID query in SQL – Hacker Rank Solution Disclaimer: The above Problem (Select By … Read More

## Select All queary in SQL – Hacker Rank Solution

Problem Query all columns (attributes) for every row in the CITY table. Input Format The CITY table is described as follows: Select All queary in SQL – Hacker Rank Solution Disclaimer: The above Problem (Select All … Read More

## Revising the Select Query II – Hacker Rank Solution

Problem Query the names of all American cities in CITY with populations larger than 120000. The CountryCode for America is USA. Input Format The CITY table is described as follows:  Revising the Select Query II – Hacker Rank … Read More

## Revising the Select Query I – Hacker Rank Solution

Problem Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA. Input Format The CITY table is described as follows:  Revising the Select Query I – Hacker Rank … Read More