Sort by

recency

|

1778 Discussions

|

  • + 0 comments

    SELECT s.name FROM students s JOIN packages sp ON s.id = sp.id JOIN friends f ON s.id = f.id JOIN packages fp ON f.friend_id = fp.id WHERE fp.salary > sp.salary ORDER BY fp.salary;

  • + 0 comments

    ;WITH SalryCTE AS (

    select S.id, S.friend_id, SP.salary AS Salary, FP.Salary AS friendsalary FROM Friends S left join Packages SP ON S.id=SP.id left join Packages FP ON S.friend_id=FP.id ) SELECT S.Name FROM Students S join SalryCTE SC ON S.id=SC.id where SC.friendsalary>SC.Salary order by SC.friendsalary;

  • + 0 comments
    select name from (
    select s.name
            ,(select Salary from Packages fin where fin.ID =f.Friend_ID  ) Fsalary
            ,p.Salary
            ,(select Name from Students fin where fin.ID =f.Friend_ID  ) FName
            ,case 
                when p.Salary < (select Salary from Packages fin where fin.ID =f.Friend_ID  ) then 'Higher' end status
    from 
    Students s left join Friends f on s.id=f.id 
    left join Packages p on s.id=p.id
        ) tbl
    where tbl.status='Higher'
    order by Fsalary
    
  • + 1 comment
    select name
    from    (select s1.name, p2.id, p2.salary 
            from students s1 join packages p2 on s1.id= p2.id
            order by p2.salary asc) as jo1n
        join
            (select f1.id, f1.friend_id, p1.salary
            from friends f1 join packages p1 on f1.friend_id= p1.id
            order by p1.salary asc) as jo2n
        on jo1n.id=jo2n.id
    where   jo2n.salary > jo1n.salary
    order by jo2n.salary;
    
  • + 0 comments

    with cte1 as( SELECT s.id as id, s.name as name, p.salary as salary, f.friend_id as friend_id FROM Students s JOIN Friends f ON s.id = f.id JOIN packages p ON s.id = p.id) SELECT c1.name as main_name FROM cte1 c1 JOIN students s1 ON c1.friend_id = s1.id JOIN packages p2 ON p2.id = s1.id WHERE p2.salary > c1.salary ORDER BY p2.salary;