We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
WITH person_CTE AS
(SELECT s.ID AS person_id, s.Name AS person_name, p.Salary AS person_salary FROM Students s
JOIN Packages p ON p.ID = s.ID) ,
friend_CTE AS
(SELECT f.ID AS person_id, f.Friend_ID AS pal_id, p.Salary AS pal_salary FROM Friends f
JOIN Packages p on f.Friend_ID = p.ID)
SELECT pcte.person_name FROM person_CTE pcte
JOIN friend_CTE fcte ON pcte.person_id = fcte.person_id
WHERE fcte.pal_salary > pcte.person_salary
ORDER BY fcte.pal_salary ASC;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Placements
You are viewing a single comment's thread. Return to all comments →
WITH person_CTE AS (SELECT s.ID AS person_id, s.Name AS person_name, p.Salary AS person_salary FROM Students s JOIN Packages p ON p.ID = s.ID) ,
friend_CTE AS (SELECT f.ID AS person_id, f.Friend_ID AS pal_id, p.Salary AS pal_salary FROM Friends f JOIN Packages p on f.Friend_ID = p.ID)
SELECT pcte.person_name FROM person_CTE pcte JOIN friend_CTE fcte ON pcte.person_id = fcte.person_id WHERE fcte.pal_salary > pcte.person_salary ORDER BY fcte.pal_salary ASC;