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.
  1. Prepare
  2. SQL
  3. Advanced Join
  4. Placements
  5. Discussions

Placements

Sort by

recency

|

1778 Discussions

|

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

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

  • LIA_UIDSYA
     + 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

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

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