Status Report

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Problem

The operations team suspects that too many orders are sitting in non-terminal states. For each order status, they want to see the number of orders and the average profit. Skip any orders that have no status on record. Only include statuses that have at least five orders behind them, and list them from most orders to fewest.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.