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 STD AS (SELECT ST.NAME AS STUDENT_NAME, FR.FRIEND_ID AS FRIEND_ID, PA.SALARY AS STUDENT_SALARY
FROM STUDENTS ST
JOIN FRIENDS FR ON ST.ID = FR.ID
JOIN PACKAGES PA ON FR.ID = PA.ID),
FRI AS (SELECT FRR.FRIEND_ID AS FRIEND_ID, PAA.SALARY AS FRIEND_SALARY
FROM FRIENDS FRR
JOIN PACKAGES PAA ON FRR.FRIEND_ID = PAA.ID)
SELECT S.STUDENT_NAME
FROM STD S
JOIN FRI F ON S.FRIEND_ID = F.FRIEND_ID
WHERE F.FRIEND_SALARY > S.STUDENT_SALARY
ORDER BY F.FRIEND_SALARY
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 STD AS (SELECT ST.NAME AS STUDENT_NAME, FR.FRIEND_ID AS FRIEND_ID, PA.SALARY AS STUDENT_SALARY FROM STUDENTS ST JOIN FRIENDS FR ON ST.ID = FR.ID JOIN PACKAGES PA ON FR.ID = PA.ID),
FRI AS (SELECT FRR.FRIEND_ID AS FRIEND_ID, PAA.SALARY AS FRIEND_SALARY FROM FRIENDS FRR JOIN PACKAGES PAA ON FRR.FRIEND_ID = PAA.ID)
SELECT S.STUDENT_NAME FROM STD S JOIN FRI F ON S.FRIEND_ID = F.FRIEND_ID WHERE F.FRIEND_SALARY > S.STUDENT_SALARY ORDER BY F.FRIEND_SALARY