# Regional Order Summary

> Region by region. The order numbers tell the story.

Canonical URL: <https://datadriven.io/problems/regional_order_summary>

Domain: SQL · Difficulty: medium · Seniority: L3

## Problem

The ops team is preparing a regional performance recap. Skip orders with no region on file. For every region with at least five orders, show the region, its order count, and its total profit. Rank from highest total profit down, breaking ties alphabetically by region.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/regional_order_summary)
- [SQL Interview Questions](https://datadriven.io/sql-interview-questions)
- [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep)
- [Daily Challenge](https://datadriven.io/daily)

---

Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.