Posts
기록
Cancel

# 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...

# Draw The Triangle 2

Draw The Triangle 2 URL : https://www.hackerrank.com/challenges/draw-the-triangle-2/problem P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): * * *...

# Draw The Triangle 1

Draw The Triangle 1 URL : https://www.hackerrank.com/challenges/draw-the-triangle-1/problem P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): * * * ...

# Average Population

Average Population URL : https://www.hackerrank.com/challenges/average-population/problem Query the average population for all cities in CITY, rounded down to the nearest integer. MySQL, Or...

# Average Population of Each Continent

Average Population of Each Continent URL : https://www.hackerrank.com/challenges/average-population-of-each-continent/problem Given the CITY and COUNTRY tables, query the names of all the con...

# Asian Population

Asian Population URL : https://www.hackerrank.com/challenges/asian-population/problem Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is ...