SQL Practice Logo

SQLPractice Online

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)