Level 7 - ArchitectQuery-Based Questionsm1 indexing strategy
Covering Index Candidate for Recent Paid Orders
Return top 50 recent paid orders with order_id, customer_id, total_amount from last 3 days for status='PAID'.
Schema Context
orders(order_id, customer_id, total_amount, status, created_at)