Order Status Revenue Above 1800

Summarize order statuses whose total revenue is above 1800. 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 1800. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.

Difficulty: Advanced
SQL concept: HAVING

This Pro challenge keeps its schema, dataset and solution behind subscription access. No protected answer content is included in public SEO data.