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

|

1890 Discussions

|

  • wrigprajapati
     + 0 comments

    SELECT Students.Name FROM ( SELECT Friends.ID, Friends.Friend_ID, Packages.Salary as Friend_Salary FROM Friends JOIN Packages ON Packages.ID = Friends.Friend_ID) as a JOIN Students ON a.ID = Students.ID JOIN Packages ON a.ID = Packages.ID WHERE a.Friend_Salary > Packages.Salary ORDER BY a.Friend_Salary ASC;

  • limigitser
     + 0 comments
        cte AS (SELECT a.id id, a.friend_id fid, b.name name, c.salary sly FROM Friends a
        INNER JOIN Students b ON a.friend_id = b.id
        INNER JOIN Packages c ON a.friend_id = c.id)
SELECT a.name FROM Students a
INNER JOIN cte b ON a.id = b.id
INNER JOIN Packages c ON a.id = c.id
WHERE c.salary < b.sly
ORDER BY b.sly;

  • anaistong
     + 0 comments

    with friend_salary as ( select p.salary, f.id from packages as p inner join friends as f on p.id = f.friend_id)

    SELECT s.name from students as s inner join friend_salary as f on s.id = f.id inner join packages as p on s.id = p.id where p.salary < f.salary order by f.salary;

  • gpdurga06
     + 0 comments

    SELECT s.Name FROM Students s JOIN Friends f ON s.ID = f.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;

  • lilithasami205
     + 0 comments
    with best_friends_salary as (
    select salary, friends.id
    from packages
    join friends on packages.id = friends.friend_id
)
select name
from students
join best_friends_salary on best_friends_salary.id = students.id
join packages on packages.id = students.id
where best_friends_salary.salary > packages.salary
order by best_friends_salary.salary