EasyNo. 2329LeetCode Premium
Product Sales Analysis V — LeetCode 2329 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: Sales +-------------+-------+ | Column Name | Type | +-------------+-------+ | sale_id | int | | product_id | int | | user_id | int | | quantity | int | +-------------+-------+ sale_id contains unique values. product_id is a foreign key (column with unique values) to Product table.Example
+-------------+-------+
| Column Name | Type |
+-------------+-------+
| sale_id | int |
| product_id | int |
| user_id | int |
| quantity | int |
+-------------+-------+
sale_id contains unique values.
product_id is a foreign key (column with unique values) to Product table.
Each row of this table shows the ID of the product and the quantity purchased by a user.Python solution
import duckdb
import pandas as pd
def solution(sales: pd.DataFrame, product: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Sales", sales)
con.register("Product", product)
return con.execute("""SELECT user_id, SUM(quantity * price) AS spending
FROM
Sales
JOIN Product USING (product_id)
GROUP BY 1
ORDER BY 2 DESC, 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 2329. Product Sales Analysis V?
LeetCode 2329. Product Sales Analysis V is rated Easy on LeetCode.
- What topics does LeetCode 2329. Product Sales Analysis V cover?
LeetCode 2329. Product Sales Analysis V is tagged Database on LeetCode.
- Is LeetCode 2329. Product Sales Analysis V a premium problem?
Yes. LeetCode 2329. Product Sales Analysis V is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.