Posts
기록
Cancel

Revising Aggregations - The Sum Function

Revising Aggregations - The Sum Function URL : https://www.hackerrank.com/challenges/revising-aggregations-sum/problem Query the total population of all cities in CITY where District is Calif...

Revising Aggregations - The Count Function

Revising Aggregations - The Count Function URL : https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem Query a count of the number of cities in CITY having a ...

Revising Aggregations - Averages

Revising Aggregations - Averages URL : https://www.hackerrank.com/challenges/revising-aggregations-the-average-function/problem Query the average population of all cities in CITY where Distri...

Population Density Difference

Population Density Difference URL : https://www.hackerrank.com/challenges/population-density-difference/problem Query the difference between the maximum and minimum populations in CITY. MyS...

Japanese Cities' Names

Japanese Cities’ Names URL : https://www.hackerrank.com/challenges/japanese-cities-name/problem Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN....

Japanese Cities' Attributes

Japanese Cities’ Attributes URL : https://www.hackerrank.com/challenges/japanese-cities-attributes/problem Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for J...

Japan Population

Japan Population URL : https://www.hackerrank.com/challenges/japan-population/problem Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN. MyS...

Higher Than 75 Marks

Higher Than 75 Marks URL : https://www.hackerrank.com/challenges/more-than-75-marks/problem Query the Name of any student in STUDENTS who scored higher than 75 Marks. Order your output by the...

Employee Salaries

Employee Salaries URL : https://www.hackerrank.com/challenges/salary-of-employees/problem Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employ...

Employee Names

Employee Names URL : https://www.hackerrank.com/challenges/name-of-employees/problem Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in a...