[HackerRank] Placements 문제 풀이 mysql
by darami[HackerRank] Placements 문제 풀이 mysql
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
SELECT s.name as name FROM Students s JOIN Friends f ON f.id=s.id JOIN Packages p ON p.id=s.id JOIN Packages p2 ON f.friend_id=p2.id WHERE p2.salary > p.salary ORDER BY p2.salary
정말 빠르고 쉽게 풀었다.
실력이 늘고 있는게 느껴진다. 뿌듯하다!
+ SQL 스터디로 다양한 문제 풀이 보강
![[HackerRank] Symmetric Pairs mysql 글의 미리보기 사진](https://img1.daumcdn.net/thumb/R100x0/?scode=mtistory2&fname=https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FbNIiUf%2FbtrCOqtCurt%2FJ2aBVLNspRBt4hkzFKK2XK%2Fimg.png)
![[HackerRank] SQL Project Planning mysql 문제 풀이 글의 미리보기 사진](https://img1.daumcdn.net/thumb/R100x0/?scode=mtistory2&fname=https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FoiBzP%2FbtrCH3GpjGt%2FNTheegGwX2JXXhjcRliMqk%2Fimg.png)
![[HackerRank] Contest Leaderboard 문제 풀이 mysql 글의 미리보기 사진](https://img1.daumcdn.net/thumb/R100x0/?scode=mtistory2&fname=https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FvZLRO%2FbtrCwhLhuJL%2Fuc4qzGMlnzNQQzOWKB0xs0%2Fimg.png)
![[HackerRank] Challenges 문제 풀이 mysql 글의 미리보기 사진](https://img1.daumcdn.net/thumb/R100x0/?scode=mtistory2&fname=https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FvIz1R%2FbtrCrPPFlfr%2F4l03E0tigrEgtGQmri2ibK%2Fimg.png)