SQL Basics for Data Work

EasySQL · PostgreSQL

Problem

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

Tablesorders

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.