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/the-company/problem?isFullScreen=true New Companies | HackerRank Find total number of employees. www.hackerrank.com [문제] Amber's conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy: Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total num..