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

Показать описание

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

Рекомендации по теме

Комментарии

i was directly using joins and and a where filter and it did not click me that one salespoerson can have multiple order and if even one order was of company red I needed to exclude it, hence this won't work and it is better to get list of red orders and then filter them

mickyman

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'))

archnabhalerao

# Write your MySQL query statement below

select name
from SalesPerson
where sales_id not in (select sales_id
from Orders
where com_id = (select com_id from Company where name = 'RED'))

sanketarekar

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

pritamm

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

parthbihani

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")
)

neerajkumawat

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-lzzq

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

mohdzuhaib-rm

This solution is not working in my Leetcode.

seematiwari

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

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

LeetCode 607 - Sales Person - Interview Coding Round

607. Sales Person leetcode solution

SQL Interview Questions |Leetcode SQL 607.Sales Person #leetcode #sqlinterviewquestions

LeetCode 607 | Sales Person | SubQuery | Left Join | Inner Join | SQL

MSSQL Solution for Leet Code Problem 607: Sales Person

LeetCode Medium 608 Uber & Amazon Interview SQL Question with Detailed Explanation

Leetcode SQL Challenge - 607. Sales Person

Stop solving 500+ Leetcode problems

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

Leetcode 183 | Customers Who Never Order | FAANG SQL Left Join Interview Question

LeetCode Medium 2372 “Influence of Each Salesperson' Interview SQL Question Explanation | EDS

MySQL - Leetcode 607 Walkthrough- Sales Person

Leetcode Hard SQL Problem | Human Traffic of Stadium

AMAZON LeetCode Medium 2324 “Product Sales Analysis IV' Interview SQL Question Explanation | ED...

LeetCode 1511 Amazon & Facebook Interview SQL Question with Detailed Explanation | Practice SQL

AMAZON & LINKEDIN LeetCode Medium “Article Views II' 1149 Interview SQL Question Explanatio...

LeetCode Hard 615 'Average Salary: Departments VS Company' Amazon Interview SQL Question E...

LeetCode 1082: Sales Analysis I [SQL]

SQL Leetcode Problem Solving 6

Easy Leetcode Problem 610 | SQL | Interview Question | With Explanation

How to Start Leetcode (as a beginner)

LeetCode 511 - Game Play Analysis I - SQL Group By

613. Shortest Distance in a Line | Leetcode SQL Easy