혜온의 이것저것

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

https://www.hackerrank.com/challenges/weather-observation-station-20/problem?isFullScreen=true Weather Observation Station 20 | HackerRank Query the median of Northern Latitudes in STATION and round to 4 decimal places. www.hackerrank.com 문제 A median is defined as a number separating the higher half of a data set from the lower half. Query the median of the Northern Latitudes (LAT_N) from STATIO..