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

Placements

Sort 768 Discussions, By:

  • deepthi_
     + 19 comments
    Select S.Name
From ( Students S join Friends F Using(ID)
       join Packages P1 on S.ID=P1.ID
       join Packages P2 on F.Friend_ID=P2.ID)
Where P2.Salary > P1.Salary
Order By P2.Salary;

  • carrielstylem
     + 5 comments

    simple in mysql, use alias:

    select s.name from students s inner join friends f on s.id=f.id inner join packages p on p.id=s.id inner join packages p1 on p1.id=f.friend_id where (p1.salary-p.salary)>0 order by p1.salary;

  • bukyte_neringa
     + 0 comments

    I found other solutions here too complicated without any specific reason. This is my simple solution for MySQL:

    SELECT s.name
FROM students s
JOIN friends f
ON s.id = f.id
JOIN packages p
ON f.id = p.id
JOIN packages p2
ON f.friend_id = p2.id
WHERE p.salary < p2.salary
ORDER BY p2.salary;

  • alanxu_80
     + 5 comments

    Oracle solution:

    select s.name from students s, friends f, packages p, packages p2 where s.id = f.id and f.friend_id = p2.id and s.id = p.id and p.salary < p2.salary order by p2.salary;

  • san28v
     + 4 comments

    My simple solution using SQL Server:

    SELECT S.Name
FROM Students S WITH (NOLOCK)
INNER JOIN Friends F WITH (NOLOCK) ON S.ID = F.ID
INNER JOIN Packages P WITH (NOLOCK) ON P.ID = S.ID
INNER JOIN Packages PF WITH (NOLOCK) ON PF.ID = F.Friend_ID AND P.Salary < PF.Salary
ORDER BY PF.Salary
Load more conversations