SQL for Business Insights | Dataford Interview Questions

How have you utilized SQL in your previous roles to support business decisions?

Demonstrate your approach by analyzing the provided Datadog usage records for the first quarter of 2025. Return one summary row per named service and exclude records outside the quarter or without a service name.

Output

Columns: service_name and total_host_hours
One row per service with its total host hours during the quarter
Sort by total_host_hours descending, then service_name ascending for ties

Schema

datadog_usage

Column	Type	Description
usage_idPK	INT	Unique usage record identifier
service_name	VARCHAR(100)	Datadog service or product area
usage_date	DATE	Date associated with the usage record
host_hours	DECIMAL(10,2)	Recorded monitored host hours

Your question is SQL for Business Insights. Start with the requirements and the one table 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

How have you utilized SQL in your previous roles to support business decisions?

Output

Columns: service_name and total_host_hours
One row per service with its total host hours during the quarter
Sort by total_host_hours descending, then service_name ascending for ties

Schema

datadog_usage

Column	Type	Description
usage_idPK	INT	Unique usage record identifier
service_name	VARCHAR(100)	Datadog service or product area
usage_date	DATE	Date associated with the usage record
host_hours	DECIMAL(10,2)	Recorded monitored host hours

Your question is SQL for Business Insights. Start with the requirements and the one table 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.