SQL for Deliveries by Team | Dataford Interview Questions

Write a SQL query to find the total number of packages delivered by each team in the last month.

Use the previous calendar month as the reporting period. Include every team, including teams with no qualifying deliveries.

Output

One row per team with columns team_name and total_packages_delivered
Include only packages with a delivered status during the previous calendar month
Order by total_packages_delivered descending, then team_name ascending

teams

Column	Type	Description
team_idPK	INT	Unique identifier for the delivery team
team_name	VARCHAR(100)	Name of the delivery team
station_code	VARCHAR(20)	FedEx operating station code

deliveries

Column	Type	Description
package_idPK	BIGINT	Unique identifier for the package
team_id	INT	Team assigned to the package
delivery_status	VARCHAR(30)	Current package delivery status
delivered_at	TIMESTAMP	Timestamp when the package was delivered

Your question is SQL for Deliveries by Team. 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.