How hard is LeetCode 1532. The Most Recent Three Orders?

LeetCode 1532. The Most Recent Three Orders is rated Medium on LeetCode.

What topics does LeetCode 1532. The Most Recent Three Orders cover?

LeetCode 1532. The Most Recent Three Orders is tagged Database on LeetCode.

Is LeetCode 1532. The Most Recent Three Orders a premium problem?

Yes. LeetCode 1532. The Most Recent Three Orders is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.

The Most Recent Three Orders — LeetCode 1532 Python Solution

MediumLeetCode PremiumDatabase

Problem: #1532
Reading time: 4 min
Source: leetcode.com

Table schema

SQL

Table: Customers +---------------+---------+ | Column Name | Type | +---------------+---------+ | customer_id | int | | name | varchar | +---------------+---------+ customer_id is the column with unique values for this table. This table contains information about customers.

Example

SQL

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| customer_id   | int     |
| name          | varchar |
+---------------+---------+
customer_id is the column with unique values for this table.
This table contains information about customers.

Python solution

Python

import duckdb
import pandas as pd

def solution(customers: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Customers", customers)
    con.register("Orders", orders)
    return con.execute("""WITH
    T AS (
        SELECT
            *,
            ROW_NUMBER() OVER (
                PARTITION BY customer_id
                ORDER BY order_date DESC
            ) AS rk
        FROM
            Orders
            JOIN Customers USING (customer_id)
    )
SELECT name AS customer_name, customer_id, order_id, order_date
FROM T
WHERE rk <= 3
ORDER BY 1, 2, 4 DESC;""").df()

Complexity

Measure	Complexity
Time	O(n log n) (typical)
Space	O(n) auxiliary

Frequently asked questions

How hard is LeetCode 1532. The Most Recent Three Orders?: LeetCode 1532. The Most Recent Three Orders is rated Medium on LeetCode.
What topics does LeetCode 1532. The Most Recent Three Orders cover?: LeetCode 1532. The Most Recent Three Orders is tagged Database on LeetCode.
Is LeetCode 1532. The Most Recent Three Orders a premium problem?: Yes. LeetCode 1532. The Most Recent Three Orders is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.