hackerrank

DB/SQL오답노트

[DB/SQL오답노트] HackerRank Top Competitors

1.문제 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 output in descending order by the total number of challenges in which the hacker earned a full score. If more than one hacker received full scores in same numb..

DB/SQL오답노트

[DB/SQL오답노트/HackerRank] Average Population of Each Continent

1.문제 Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to the nearest integer. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: 2.내 풀이 SELECT COUNTRY.Continent, trunc(avg(CITY.population)) FROM ..

각시탈코더
'hackerrank' 태그의 글 목록