EasyNo. 1082LeetCode Premium
Sales Analysis I — LeetCode 1082 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: Product +--------------+---------+ | Column Name | Type | +--------------+---------+ | product_id | int | | product_name | varchar | | unit_price | int | +--------------+---------+ product_id is the primary key (column with unique values) of this table. Each row of this table indicates the name and the price of each product.Example
+--------------+---------+
| Column Name | Type |
+--------------+---------+
| product_id | int |
| product_name | varchar |
| unit_price | int |
+--------------+---------+
product_id is the primary key (column with unique values) of this table.
Each row of this table indicates the name and the price of each product.Python solution
import duckdb
import pandas as pd
def solution(product: pd.DataFrame, sales: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Product", product)
con.register("Sales", sales)
return con.execute("""SELECT seller_id
FROM Sales
GROUP BY seller_id
HAVING
SUM(price) >= ALL(
SELECT SUM(price)
FROM Sales
GROUP BY seller_id
);""").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 1082. Sales Analysis I?
LeetCode 1082. Sales Analysis I is rated Easy on LeetCode.
- What topics does LeetCode 1082. Sales Analysis I cover?
LeetCode 1082. Sales Analysis I is tagged Database on LeetCode.
- Is LeetCode 1082. Sales Analysis I a premium problem?
Yes. LeetCode 1082. Sales Analysis I is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.