Order Status Revenue Above 750

Summarize order statuses whose total revenue is above 750. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Summarize order statuses whose total revenue is above 750. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.

Difficulty: Advanced
SQL concept: HAVING