SQL Practice Logo

SQLPractice Online

Level 3 - IntermediateQuery-Based Questions

Top Customers by 90-Day Revenue

Return the top 3 customers by total revenue in the last 90 days. Show customer_id, customer_name, and total_revenue.

Schema Context

customers(id, name), orders(id, customer_id, total_amount, order_date)