SQL Practice Logo

SQLPractice Online

Level 2 - JuniorQuery-Based Questions

Customer Spend Summary

Write a SQL query to return customer_id, customer_name, and total_spend for customers who placed at least 2 orders. Sort by total_spend descending.

Schema Context

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