Essential Tools for Data Analysis | Dataford Interview Questions

What tools do you consider essential for data analysis?

For this SQL exercise, use the tool catalog and return only tools marked as essential. Include the tool name and category, ordered alphabetically by tool name.

Output

One row per essential tool.
Columns: tool_name, category.
Exclude tools that are not marked essential or have no essentiality value.
Order by tool_name ascending.

Schema

analysis_tools

Column	Type	Description
tool_idPK	INT	Unique identifier for the analysis tool
tool_name	VARCHAR(100)	Name of the data analysis tool
category	VARCHAR(60)	Primary category of the tool
is_essential	BOOLEAN	Whether the tool is considered essential for data analysis

Your question is Essential Tools for Data Analysis. 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