EasyNo. 1327
List the Products Ordered in a Period — LeetCode 1327 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: Products +------------------+---------+ | Column Name | Type | +------------------+---------+ | product_id | int | | product_name | varchar | | product_category | varchar | +------------------+---------+ product_id is the primary key (column with unique values) for this table. This table contains data about the company's products.Example
+------------------+---------+
| Column Name | Type |
+------------------+---------+
| product_id | int |
| product_name | varchar |
| product_category | varchar |
+------------------+---------+
product_id is the primary key (column with unique values) for this table.
This table contains data about the company's products.Python solution
import duckdb
import pandas as pd
def solution(products: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Products", products)
con.register("Orders", orders)
return con.execute("""SELECT product_name, SUM(unit) AS unit
FROM
Orders AS o
JOIN Products AS p ON o.product_id = p.product_id
WHERE DATE_FORMAT(order_date, '%Y-%m') = '2020-02'
GROUP BY o.product_id
HAVING unit >= 100;""").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 1327. List the Products Ordered in a Period?
LeetCode 1327. List the Products Ordered in a Period is rated Easy on LeetCode.
- What topics does LeetCode 1327. List the Products Ordered in a Period cover?
LeetCode 1327. List the Products Ordered in a Period is tagged Database on LeetCode.