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

|

1832 Discussions

|

  • caroll_cca_cc
     + 0 comments

    /Step 1: Students's Salaries table/ WITH Students_Salaries AS (SELECT A.ID, A.Name, B.Salary, C.friend_ID FROM Students A INNER JOIN Packages B ON A.ID = B.ID INNER JOIN Friends C ON A.ID = C.ID)

    /Step 2: Join friend_id with ID/ SELECT A.Name FROM Students_Salaries A LEFT JOIN Packages B ON A.friend_ID = B.ID WHERE (A.Salary < B.Salary) ORDER BY B.Salary;

  • rohansrinivas810
     + 0 comments

    select Name from (select S.ID, S.NAme, P1.salary as salary1, F.Friend_ID, P2.salary as salary2 from Students S join Packages P1 on S.ID = P1.ID join Friends F on S.ID = F.ID join Packages P2 on F.Friend_ID = P2.ID) as quer where salary1 < salary2 order by salary2

  • ankitsingh28jan
     + 0 comments

    SELECT s.Name FROM Students s JOIN Friends f ON s.ID = f.ID JOIN Packages sp ON s.ID = sp.ID -- JOINING STUDENT'S PACKAGE JOIN Packages fp ON f.Friend_ID = fp.ID -- JOINING FRIEND'S PACKAGE WHERE fp.Salary > sp.Salary ORDER BY fp.Salary;

  • kenneth_teng_hu1
     + 0 comments

    select s1.Name from Friends f left join Students s1 on f.ID = s1.ID left join Packages p1 on f.ID = p1.ID left join Packages p2 on f.Friend_ID = p2.ID where p1.Salary < p2.Salary order by p2.Salary

  • jared291095
     + 0 comments
    WITH FILTERED AS (
    SELECT
        NAME,
        P.SALARY AS FRIEND_SALARY,
        (SELECT PA.SALARY FROM PACKAGES AS PA WHERE F.ID = PA.ID) AS MY_SALARY
    FROM STUDENTS AS S
    LEFT JOIN FRIENDS AS F ON S.ID = F.ID 
    LEFT JOIN PACKAGES AS P ON F.FRIEND_ID = P.ID
)
SELECT NAME FROM FILTERED
WHERE FRIEND_SALARY > MY_SALARY
ORDER BY FRIEND_SALARY