목록전체 글 (128)

Milky's note

[HackerRank](M) Top Competitors

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..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 31. 16:35
[HackerRank](M) Placements

https://www.hackerrank.com/challenges/placements/problem?isFullScreen=true Placements | HackerRank Write a query to output the names of those students whose best friends got offered a higher salary than them. www.hackerrank.com [문제] You are given three tables: Students, Friends and Packages. Students contains two columns: ID and Name. Friends contains two columns: ID and Friend_ID (ID of the ONL..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 31. 15:33
[HackerRank](M) Contest Leaderboard

https://www.hackerrank.com/challenges/contest-leaderboard/problem?isFullScreen=true Contest Leaderboard | HackerRank Generate the contest leaderboard. www.hackerrank.com [문제] You did such a great job helping Julia with her last coding contest challenge that she wants you to work on this one, too! The total score of a hacker is the sum of their maximum scores for all of the challenges. Write a qu..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 30. 16:51
[HackerRank](M) Weather Observation Station 20

https://www.hackerrank.com/challenges/weather-observation-station-20/problem?isFullScreen=true&h_r=next-challenge&h_v=zen 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 ..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 28. 18:33
Prev 1 ··· 11 12 13 14 15 16 17 ··· 32 Next