Sort by

recency

|

1848 Discussions

|

  • + 0 comments

    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

  • + 0 comments

    ` 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;

    `

  • + 0 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;

  • + 0 comments

    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;

  • + 0 comments

    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;