혜온의 이것저것

https://www.hackerrank.com/challenges/full-score/problem?isFullScreen=true Top Competitors | HackerRank Query a list of top-scoring hackers. www.hackerrank.com 문제 Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respective hacker_id and name of hackers who achieved full scores for more than one challenge. Order your o..

https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com 문제 You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Grades contains the following data: Ketty gives Eve a task to generate a report containing thre..

https://www.hackerrank.com/challenges/average-population-of-each-continent/problem?isFullScreen=true Average Population of Each Continent | HackerRank Query the names of all continents and their respective city populations, rounded down to the nearest integer. www.hackerrank.com 문제 Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective a..

https://www.hackerrank.com/challenges/african-cities/problem?isFullScreen=true African Cities | HackerRank Query the names of all cities on the continent 'Africa'. www.hackerrank.com 문제 Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are des..

https://www.hackerrank.com/challenges/asian-population/problem?isFullScreen=true Population Census | HackerRank Query the sum of the populations of all cities on the continent 'Asia'. www.hackerrank.com 문제 Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format ..