AlgorithmJourney/LeetCode/sql/LeetCode1532.sql at main · HenryJi529/AlgorithmJourney · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
select
    customer_name,
    customer_id,
    order_id,
    order_date
from (
        select c.name as "customer_name", o.customer_id, o.order_id, o.order_date, ROW_NUMBER() over (
                partition by
                    o.customer_id
                order by order_date desc
            ) ranking
        from Orders o
            left join Customers c on o.customer_id = c.customer_id
    ) t
where
    ranking <= 3
order by
    customer_name,
    customer_id,
    order_date desc