The Most Recent Three Orders

For each customer, return their three most recent orders from an orders table, ranked by order date (with ID as a tie-breaker). The core challenge is filtering to the top‑k rows per group—typically solved with SQL window functions (ROW_NUMBER()/PARTITION BY) or correlated subqueries.