LeetCode 607 Amazon Interview SQL Question with Detailed Explanation | Practice SQL

Question: leetcode.com/p...
In this video I solve and explain a leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question includes points to keep in mind to develop SQL queries.
LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.
If you found this helpful, Like and Subscribe to the channel for more content.
#LeetCodeSQL #FAANG #SQLinterviewQuestions

[@neerajkumawat3386]

select name from salesperson where sales_id not in ( select distinct sales_id from orders where com_id = (select com_id from company where name = "RED") )

[@parthbihani7360]

why this is wrong select name from SalesPerson where sales_id NOT IN (select sales_id from orders where com_id = 1)

[@sypark102]

Thank you :)

[@archnabhalerao7001]

We can also write the query Instead of doing all that kind of stuff as -->select name from SalesPerson where sales_id not in( select sales_id from Orders where com_id=(select com_id from Company where name like 'RED'))

[@user-rp7df2on1w]

select sum(orangecount) orangecount , sum(applecount) applecount from (select chestid,orangecount,applecount from box union select chestid,orangecount,applecount from chest) a

[@pritamm6386]

why we are not getting right answer when we neglect all name = 'Red' in cte and then compare with salesperson table?

[@PIYUSH-lz1zq]

sir , i often get confused to take which table on left while doing left join . initially i was taking company on left side cause based on company we r filtering !! please on it.

[@PIYUSH-lz1zq]

Please clear this doubt

[@kshitijpandey78]

the left join is applied on the table from where we have to check the condition .. Here we take company table as the left join as we have to check the name is Not red.

[@seematiwari1441]

This solution is not working in my Leetcode.

[@chandravideo]

yes they have added test case in which there a null value in not in which is falling

[@mlvprasadofficial]

71