Customers Spending Above 900

Find customers whose total completed-order spend exceeds 900. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Find customers whose total completed-order spend exceeds 900. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.

Difficulty: Advanced
SQL concept: HAVING