EasyNo. 1677LeetCode Premium
Product's Worth Over Invoices — LeetCode 1677 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: Product +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | name | varchar | +-------------+---------+ product_id is the column with unique values for this table. This table contains the ID and the name of the product.Example
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| product_id | int |
| name | varchar |
+-------------+---------+
product_id is the column with unique values for this table.
This table contains the ID and the name of the product. The name consists of only lowercase English letters. No two products have the same name.Python solution
import duckdb
import pandas as pd
def solution(product: pd.DataFrame, invoice: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Product", product)
con.register("Invoice", invoice)
return con.execute("""SELECT
name,
IFNULL(SUM(rest), 0) AS rest,
IFNULL(SUM(paid), 0) AS paid,
IFNULL(SUM(canceled), 0) AS canceled,
IFNULL(SUM(refunded), 0) AS refunded
FROM
Product
LEFT JOIN Invoice USING (product_id)
GROUP BY product_id
ORDER BY name;""").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 1677. Product's Worth Over Invoices?
LeetCode 1677. Product's Worth Over Invoices is rated Easy on LeetCode.
- What topics does LeetCode 1677. Product's Worth Over Invoices cover?
LeetCode 1677. Product's Worth Over Invoices is tagged Database on LeetCode.
- Is LeetCode 1677. Product's Worth Over Invoices a premium problem?
Yes. LeetCode 1677. Product's Worth Over Invoices is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.