Sort by

recency

|

1857 Discussions

|

  • + 0 comments

    Oracle

    WITH SalaryComparison AS (
        SELECT
            f.id as self_id,
            pf.salary AS friend_salary,
            ps.salary AS self_salary
        FROM
            Friends f
            JOIN Packages pf ON f.friend_id = pf.id
            JOIN Packages ps ON f.id = ps.id
    )
    SELECT 
        s.name
    FROM 
        SalaryComparison sc
        JOIN Students s ON sc.self_id = s.id
    WHERE
        sc.friend_salary > sc.self_salary
    ORDER BY
        sc.friend_salary ASC
    ;
    
  • + 0 comments

    SELECT NAME from Students s LEFT JOIN Friends f ON s.ID=f.ID LEFT JOIN Packages p ON f.ID=p.ID LEFT JOIN Packages p1 ON f.Friend_ID=p1.ID WHERE p1.salary>p.salary Order BY p1.salary;

  • + 0 comments

    SELECT NAME from Students s LEFT JOIN Friends f ON s.ID=f.ID LEFT JOIN Packages p ON f.ID=p.ID LEFT JOIN Packages p1 ON f.Friend_ID=p1.ID WHERE p1.salary>p.salary Order BY p1.salary;

  • + 0 comments

    MySQL select s.name from students s left join friends f on s.id = f.id left join packages p on f.id = p.id left join packages p1 on f.friend_id = p1.id where p1.salary>p.salary order by p1.salary

  • + 0 comments

    WITH CTE AS( SELECT S.ID, S.Name, P.Salary,F.Friend_ID FROM Students AS S INNER JOIN Packages AS P ON S.ID=P.ID INNER JOIN Friends AS F ON S.ID=F.ID ) , CTE2 AS( SELECT CTE.Name AS StudentName, CTE.Salary AS StudentSalary, Students.Name AS FriendName, Packages.Salary AS FriendSalary FROM CTE INNER JOIN Students ON CTE.Friend_ID=Students.ID INNER JOIN Packages ON Packages.ID=CTE.Friend_ID ) , CTE3 AS( SELECT CASE WHEN StudentSalary