EasyNo. 2082LeetCode Premium
The Number of Rich Customers — LeetCode 2082 Python Solution
- Topics
- Database
- Reading time
- 2 min
- Source
- leetcode.com
Table schema
Table: Store +-------------+------+ | Column Name | Type | +-------------+------+ | bill_id | int | | customer_id | int | | amount | int | +-------------+------+ bill_id is the primary key (column with unique values) for this table. Each row contains information about the amount of one bill and the customer associated with it.Example
+-------------+------+
| Column Name | Type |
+-------------+------+
| bill_id | int |
| customer_id | int |
| amount | int |
+-------------+------+
bill_id is the primary key (column with unique values) for this table.
Each row contains information about the amount of one bill and the customer associated with it.Python solution
import duckdb
import pandas as pd
def solution(store: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Store", store)
return con.execute("""SELECT
COUNT(DISTINCT customer_id) AS rich_count
FROM Store
WHERE amount > 500;""").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 2082. The Number of Rich Customers?
LeetCode 2082. The Number of Rich Customers is rated Easy on LeetCode.
- What topics does LeetCode 2082. The Number of Rich Customers cover?
LeetCode 2082. The Number of Rich Customers is tagged Database on LeetCode.
- Is LeetCode 2082. The Number of Rich Customers a premium problem?
Yes. LeetCode 2082. The Number of Rich Customers is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.