MediumNo. 1398LeetCode Premium
Customers Who Bought Products A and B but Not C — LeetCode 1398 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: Customers +---------------------+---------+ | Column Name | Type | +---------------------+---------+ | customer_id | int | | customer_name | varchar | +---------------------+---------+ customer_id is the column with unique values for this table. customer_name is the name of the customer.Example
+---------------------+---------+
| Column Name | Type |
+---------------------+---------+
| customer_id | int |
| customer_name | varchar |
+---------------------+---------+
customer_id is the column with unique values for this table.
customer_name is the name of the customer.Python solution
import duckdb
import pandas as pd
def solution(customers: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Customers", customers)
con.register("Orders", orders)
return con.execute("""SELECT customer_id, customer_name
FROM
Customers
LEFT JOIN Orders USING (customer_id)
GROUP BY 1
HAVING SUM(product_name = 'A') > 0 AND SUM(product_name = 'B') > 0 AND SUM(product_name = 'C') = 0
ORDER BY 1;""").df()Complexity
- Time
- O(n log n)(typical)
- Space · auxiliary
- O(n)
Related problems
| No. | Problem | Difficulty |
|---|---|---|
| 0175 | Combine Two Tables | Easy |
| 0176 | Second Highest Salary | Medium |
| 0177 | Nth Highest Salary | Medium |
| 0178 | Rank Scores | Medium |
| 0180 | Consecutive Numbers | Medium |
| 0181 | Employees Earning More Than Their Managers | Easy |
Frequently asked questions
- How hard is LeetCode 1398. Customers Who Bought Products A and B but Not C?
LeetCode 1398. Customers Who Bought Products A and B but Not C is rated Medium on LeetCode.
- What topics does LeetCode 1398. Customers Who Bought Products A and B but Not C cover?
LeetCode 1398. Customers Who Bought Products A and B but Not C is tagged Database on LeetCode.
- Is LeetCode 1398. Customers Who Bought Products A and B but Not C a premium problem?
Yes. LeetCode 1398. Customers Who Bought Products A and B but Not C is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.