LeetCode / 607.Sales Person / MySQL / Easy
2023. 12. 27. 10:53
📚문제 📝풀이 # Write your MySQL query statement below SELECT name FROM SalesPerson WHERE sales_id NOT IN (SELECT DISTINCT o.sales_id FROM Orders o JOIN Company c ON o.com_id = c.com_id AND c.name = 'RED' 정답처리 된 풀이 처음 풀이가 왜 안풀리는지 잘 이해가 되지 않아서 기록 # Write your MySQL query statement below SELECT name FROM SalesPerson WHERE sales_id NOT IN (SELECT DISTINCT o.sales_id FROM Orders o WHERE com_id = 1) JOIN 하..
