Hackerrank Placements Problem | SQL | Ashutosh Kumar

[@iamchinmaykr]

I have seen your videos in sql and Excel , please make a video on how u got into Amazon , all about you interview experience and journey so far

[@AshutoshKumaryt]

Sure

[@aasthagoyal5059]

I have used same code as yours but still giving error my code SELECT NAME FROM (SELECT E.ID, E.NAME, E.FRIEND_ID, E.SALARY PERSON, F.SALARY FRIEND FROM (SELECT C.ID, C.NAME,C.FRIEND_ID, D.Salary FROM (SELECT A.ID,A.Name,B.FRIEND_ID FROM Students A INNER JOIN Friends B ON A.ID=B.ID) C INNER JOIN PACKAGES D ON C.ID=D.ID) E INNER JOIN PACKAGES F ON F.ID = E.FRIEND_ID) G WHERE G.PERSON < G.FRIEND GROUP BY G.FRIEND where am I wrong??

[@ashfakahamed9266]

what error you are getting ?

[@ReddyNaresh20]

At last it has to be order by not group by