SQL and Data Tooling Proficiency | Dataford Interview Questions

What data analysis tools are you proficient in, and how have you used them in past projects?

For this SQL exercise, summarize tool usage across the recorded projects. Include only tools used in at least two distinct projects.

Output

One row per qualifying tool with tool_name, projects_used, total_hours, and average_rating.
Order by projects_used descending, then tool_name ascending.
Exclude rows where the tool name is missing.

project_tool_usage

Column	Type	Description
usage_idPK	INT	Unique usage record identifier
project_name	VARCHAR(100)	Name of the project
tool_name	VARCHAR(80)	Data analysis tool used
hours_used	DECIMAL(8,2)	Hours spent using the tool
outcome_rating	DECIMAL(3,2)	Project outcome rating from 1.00 to 5.00

Your question is SQL and Data Tooling Proficiency. 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.

What data analysis tools are you proficient in, and how have you used them in past projects?

For this SQL exercise, summarize tool usage across the recorded projects. Include only tools used in at least two distinct projects.

One row per qualifying tool with tool_name, projects_used, total_hours, and average_rating.
Order by projects_used descending, then tool_name ascending.
Exclude rows where the tool name is missing.

project_tool_usage

Column	Type	Description
usage_idPK	INT	Unique usage record identifier
project_name	VARCHAR(100)	Name of the project
tool_name	VARCHAR(80)	Data analysis tool used
hours_used	DECIMAL(8,2)	Hours spent using the tool
outcome_rating	DECIMAL(3,2)	Project outcome rating from 1.00 to 5.00

Your question is SQL and Data Tooling Proficiency. 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.