KEEP GOING
[MySQL] HackerRank : Placements Solution 본문
반응형
https://www.hackerrank.com/challenges/placements/problem
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
1. 정답 코드
SELECT S.Name
FROM Friends F
INNER JOIN Students S ON S.ID = F.ID
INNER JOIN Packages P ON F.ID = P.ID
INNER JOIN Packages PP ON F.Friend_ID = PP.ID
WHERE P.Salary < PP.Salary
ORDER BY PP.Salary
반응형
'code review > sql' 카테고리의 다른 글
| [MySQL] HackerRank : The Report Solution (0) | 2021.12.22 |
|---|---|
| [MySQL] HackerRank : Binary Tree Nodes Solution (0) | 2021.12.21 |
| [MySQL] HackerRank : Top Competitors Solution (0) | 2021.12.21 |
| [MySQL] HackerRank : Weather Observation Station 11 Solution (0) | 2021.12.21 |
| [MySQL] HackerRank : New Companies Solution (0) | 2021.12.20 |
'code review/sql' Related Articles
more
Comments
