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
@AshutoshKumaryt2 жыл бұрын
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??