SQL Analysis and Decisions | Dataford Interview Questions

Describe how you used a data set and what tools you used to analyze it and what decisions did you make as a result of it. Using the supplied products and orders tables, write a PostgreSQL query that produces a decision-oriented category analysis for completed orders from January through March 2025.

Output

One row per product category, with category, total_revenue, order_count, revenue_share_pct, and decision.
Include only categories represented by completed orders in the date range. Set decision to Prioritize when category revenue is at least the average category revenue; otherwise set it to Review.
Order by total_revenue descending, breaking ties alphabetically by category.

Schema

products

Column	Type	Description
product_idPK	INT	Unique product identifier
product_name	VARCHAR(100)	Product name
category	VARCHAR(50)	Product category

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
product_id	INT	Product included in the order
order_date	DATE	Order date
quantity	INT	Units ordered
unit_price	NUMERIC(10,2)	Price per unit
status	VARCHAR(20)	Order processing status

Your question is SQL Analysis and Decisions. 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