Discussion on Placements Challenge

Sort by

recency

|

1825 Discussions

|

3 days ago+ 0 comments

SELECT Stu_Name FROM (SELECT s.ID as Stu_ID,s.Name as Stu_Name,p.Salary as Stu_Sal,f.Friend_ID as FriendID from Students s left join Friends f on f.ID = s.ID left join Packages p on p.ID = s.ID) as CTE left join Packages c on c.ID = CTE.FriendID where c.Salary > Stu_Sal order by c.Salary;

4 days ago+ 0 comments

FROM 
(   
    SELECT  F.ID AS ID, 
		S.Name AS Name, 
		F.Friend_ID AS F_ID, 
		S2.Name AS F_Name
    FROM Friends AS F
    LEFT JOIN Students AS S ON F.ID = S.ID
    LEFT JOIN Students AS S2 ON F.Friend_ID = S2.ID
) AS T1

JOIN Packages AS P ON T1.ID = P.ID
JOIN Packages AS P2 ON T1.F_ID = P2.ID
WHERE P2.Salary > P.Salary
ORDER BY P2.Salary

5 days ago+ 0 comments

WITH t as( SELECT S.ID AS ID, S.Name AS Name, P.Salary AS Salary, (SELECT Salary FROM Packages WHERE ID = F.Friend_ID) AS Friend_Salary FROM Students S JOIN Friends F ON S.ID = F.ID JOIN Packages P ON F.ID = P.ID
) SELECT Name From t WHERE Friend_Salary > Salary ORDER BY Friend_Salary ASC

6 days ago+ 0 comments

select s.name from friends f join packages p on p.id=f.id join packages p2 on p2.id=f.friend_id join students s on s.id = p.id where p.salary < p2.salary order by p2.salary

6 days ago+ 0 comments

select s.Name from students s inner join Friends f on s.ID=f.ID inner join Packages sp on s.ID=sp.ID inner join Packages fp on f.Friend_ID=fp.ID where fp.salary>sp.salary order by fp.salary

Sort by

|

1825 Discussions

|

Cookie support is required to access HackerRank

Please signup or login in order to view this challenge