Rank Fulfillment Centers by Speed | Dataford Interview Questions

Write a query using window functions to rank fulfillment centers by their average package processing speed per hour at Foundation Robotics Labs.

Use completed processing records with non-null package counts and positive processing durations. Exclude centers without a valid completed processing record.

Output

One row per eligible fulfillment center with center_name, average_packages_per_hour, and speed_rank.
Rank centers from fastest to slowest; centers with equal averages share a rank.
Order by speed_rank ascending, then center_id ascending.

Schema

fulfillment_centers

Column	Type	Description
center_idPK	INT	Unique fulfillment center identifier
center_name	VARCHAR(100)	Fulfillment center name

package_processing

Column	Type	Description
processing_idPK	INT	Unique processing record identifier
center_id	INT	Fulfillment center associated with the record
packages_processed	INT	Number of packages processed
processing_hours	NUMERIC(8,2)	Hours spent processing the packages
status	VARCHAR(20)	Processing record status

Your question is Rank Fulfillment Centers by Speed. 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