Automating Manual Reporting | Dataford Interview Questions

Describe a situation where you had to use Excel or other tools to automate a manual reporting process.

For the SQL portion, write a repeatable query that produces the monthly report from the provided tables. Include all sellers, even those without qualifying orders.

Output

One row per seller, with seller_name, completed_orders, and completed_revenue.
Include only completed orders from January 2025; sellers without qualifying orders must show zero values.
Sort by completed_revenue descending, then seller_name ascending.

Schema

sellers

Column	Type	Description
seller_idPK	INT	Unique seller identifier
seller_name	VARCHAR(100)	Seller display name
region	VARCHAR(50)	Seller operating region

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
seller_id	INT	Seller associated with the order
order_date	DATE	Date the order was placed
status	VARCHAR(30)	Current order status
order_amount	DECIMAL(12,2)	Order revenue amount

Your question is Automating Manual Reporting. Start with the requirements and the two tables 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