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.
- Prepare
- SQL
- Advanced Join
- Placements
- Discussions
Placements
Placements
Sort by
recency
|
1848 Discussions
|
Please Login in order to post a comment
with cte_cal as ( select f.id, P.salary, dp.id as friendid, dp.salary as friedsal, s.name as name from Friends F INNER JOIN Packages P ON P.id = F.ID INNER JOIN Packages dP ON dP.id = F.Friend_ID INNER JOIN Students S ON S.id = P.id )
select name from cte_cal where salary < friedsal order by friedsal ASC
` WITH overall AS ( SELECT s.ID, s.Name, p.Salary FROM Students s LEFT JOIN Packages p ON s.ID = p.ID )
SELECT a.name FROM ( SELECT f.ID, s.Name as name, s.Salary as s_salary, f.Friend_ID, b.Salary as b_salary FROM Friends f LEFT JOIN overall s ON f.ID = s.ID LEFT JOIN overall b ON f.Friend_ID = b.ID ) a WHERE a.b_salary > a.s_salary ORDER BY a.b_salary;
`
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;
SELECT s.Name
FROM Friends f
JOIN Packages p1 ON f.ID = p1.ID
JOIN Packages p2 ON f.Friend_ID = p2.ID
JOIN Students s ON f.ID = s.ID
WHERE p2.Salary > p1.Salary ORDER BY p2.Salary;
SELECT NAME FROM( SELECT st.id,st.name,p1.salary as my_sal, p2.salary as frnd_sal from students as st join friends on st.id = friends.id join packages as p1 on st.id = p1.id join packages as p2 on friends.friend_id = p2.id ) WHERE frnd_sal > my_sal ORDER BY frnd_sal;