MediumNo. 2228LeetCode Premium
Users With Two Purchases Within Seven Days — LeetCode 2228 Python Solution
- Topics
- Database
- Reading time
- 4 min
- Source
- leetcode.com
Table schema
Table: Purchases +---------------+------+ | Column Name | Type | +---------------+------+ | purchase_id | int | | user_id | int | | purchase_date | date | +---------------+------+ purchase_id contains unique values. This table contains logs of the dates that users purchased from a certain retailer.Example
+---------------+------+
| Column Name | Type |
+---------------+------+
| purchase_id | int |
| user_id | int |
| purchase_date | date |
+---------------+------+
purchase_id contains unique values.
This table contains logs of the dates that users purchased from a certain retailer.Python solution
import duckdb
import pandas as pd
def solution(purchases: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Purchases", purchases)
return con.execute("""WITH
t AS (
SELECT
user_id,
DATEDIFF(
purchase_date,
LAG(purchase_date, 1) OVER (
PARTITION BY user_id
ORDER BY purchase_date
)
) AS d
FROM Purchases
)
SELECT DISTINCT user_id
FROM t
WHERE d <= 7
ORDER BY user_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 2228. Users With Two Purchases Within Seven Days?
LeetCode 2228. Users With Two Purchases Within Seven Days is rated Medium on LeetCode.
- What topics does LeetCode 2228. Users With Two Purchases Within Seven Days cover?
LeetCode 2228. Users With Two Purchases Within Seven Days is tagged Database on LeetCode.
- Is LeetCode 2228. Users With Two Purchases Within Seven Days a premium problem?
Yes. LeetCode 2228. Users With Two Purchases Within Seven Days is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.