Search results
Solution – Placements in SQL MySQL select temp1.sn from (select S.ID si,S.Name sn,P.Salary ps from Students S join Packages P on S.ID=P.ID) temp1 join (select FF.ID fi,FF.Friend_ID fd,PP.Salary pps from Friends FF join Packages PP on FF.Friend_ID=pp.ID) temp2 on temp1.si=temp2.fi and temp1.ps<temp2.pps order by temp2.pps asc;
HackerRank concepts & solutions. Contribute to BlakeBrown/HackerRank-Solutions development by creating an account on GitHub.
Effective solutions to hackerrank.com practice problems in C++, python and SQL - IhorVodko/Hackerrank_solutions
Jul 25, 2020 · Placements. Problem: 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 ONLY best...
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 ONLY best friend). Packages contains two columns: ID and Salary (offered salary in $ thousands per month).
Solution In SQL With Problem Explanation And Algorithm - THARUN1526/Placements-Sql-Hackerrank-solution
Jul 6, 2023 · The Solution. Here, I present two SQL solutions with slightly different approaches. Each has its own strengths, weaknesses, and applicability. Direct Join Approach. The first source code uses direct JOIN operations to link the necessary data from all tables:
Jul 30, 2020 · #HackerRank #SQL #PlacementsThis video contains medium level problem on SQL in HackerRank.You can go through each and every problem solved in this channel f...
Aug 8, 2022 · Sql one of the most important language asked in most of the analytics interviews, in this series i will be solving sql questions from hackerrank, hackerearth, leetcode and many other websites ...
Jan 17, 2024 · Solution SELECT s.Name FROM Students s JOIN Packages p1 ON s.ID = p1.ID JOIN Friends f ON s.ID = f.ID JOIN Packages p2 ON f.Friend_ID = p2.ID WHERE p2.Salary > p1.Salary ORDER BY p2.Salary ...