SQL for Top-Performing Vendors | Dataford Interview Questions

Write a query to identify top-performing vendors based on order history at Xometry.

Use completed Xometry orders to calculate each vendor's order count, total order value, and average order value. Return the three highest-ranked vendors, including all vendors tied at the third rank.

Output

One row per qualifying vendor with vendor_name, completed_order_count, total_completed_value, average_completed_value, and performance_rank.
Include only completed orders, order by rank and total value descending, then vendor name ascending.

Schema

vendors

Column	Type	Description
vendor_idPK	INT	Unique Xometry vendor identifier
vendor_name	VARCHAR(100)	Vendor display name
vendor_region	VARCHAR(50)	Vendor operating region

orders

Column	Type	Description
order_idPK	INT	Unique Xometry order identifier
vendor_id	INT	Vendor assigned to fulfill the order
order_status	VARCHAR(20)	Current order status
order_value	NUMERIC(12,2)	Order value in US dollars
order_date	DATE	Date the order was placed

Your question is SQL for Top-Performing Vendors. 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