Milky's note

https://solvesql.com/problems/multiple-medalist/ solvesql © Copyright 2021-2022 solvesql.com solvesql.com 문제는 다음과 같고 테이블 4개를 join 해야하기 때문에 조금 복잡했지만 순서대로 따라가서 풀다보면 금방 풀렸다. 그리고 주의해야할 점은 복수의 국적으로 메달을 수상한 선수를 찾아야하기 때문에 team이 1 이상인 것들만을 조회하였다. select distinct a.name from records r join athletes a on a.id = r.athlete_id join games g on r.game_id = g.id join teams t on r.team_id = t.id where r.medal is..

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

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