SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectQuery-Based Questionsm2 query shape optimization

Top 3 Orders Per Customer (Window Shape)

Return top 3 highest-value orders per customer with order_id, customer_id, total_amount.

Schema Context

orders(order_id, customer_id, total_amount, created_at)