tag

#anti-join

2 pages tagged

Practice › LeetCode › LeetCode (archived) › LeetCode 06xx ›

LeetCode 607: Sales Person

Problem Restatement We are given three tables: SalesPerson , Company , and Orders . The SalesPerson table stores salesperson information. Column Type Meaning sales_id int Salesperson id name varchar Salesperson name salary int Salary commission_rate int Commission rate hire_date date Hire date The Company table stores company information. Column Type Meaning com_id int Company id name varchar Company name city varchar Company city The Orders table stores order information. Column...

Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 183: Customers Who Never Order

Problem Restatement We are given two tables: Customers and Orders . Customers stores customer information. Column Type id int name varchar Orders stores order information. Column Type id int customerId int The customerId column in Orders refers to Customers.id . We need to find all customers who never placed an order. The result can be returned in any order. The official problem asks for all customers who never order anything....