Aggregate Orders by Non-Null Status | Dataford Interview Questions

Tell me about a time you used SQL to answer a simple data question and validated the result.

For this exercise, use the supplied orders table to count orders for each non-null status and describe how you would independently validate the result.

Output

One row per non-null order_status, with columns order_status and order_count.
Exclude orders whose status is NULL.
Order by order_count descending, then order_status ascending for ties.

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
order_status	VARCHAR(30)	Current order status
order_total	NUMERIC(10,2)	Total value of the order

Your question is Aggregate Orders by Non-Null Status. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem