Preferred Visualization Tools | Dataford Interview Questions

What specific tools or technologies do you prefer for data visualization, and why?

Translate the preference evidence into a ranked SQL result using the available tool and feedback records. Include tools without feedback so the output distinguishes established preferences from tools with no supporting ratings.

Output

One row per visualization tool with tool_name, tool_category, feedback_count, average_rating, preference_reasons, and preference_rank
Include every tool, preserve NULL averages for tools without ratings, and concatenate non-NULL reasons chronologically
Sort by preference rank, then tool name alphabetically; tied and unrated tools share ranks

Schema

visualization_tools

Column	Type	Description
tool_idPK	INT	Unique visualization tool identifier
tool_name	VARCHAR(100)	Name of the visualization tool
tool_category	VARCHAR(50)	General category of the tool

visualization_feedback

Column	Type	Description
feedback_idPK	INT	Unique feedback identifier
tool_id	INT	Referenced visualization tool
rating	INT	Preference rating from 1 to 5
reason	VARCHAR(255)	Reason supporting the rating
submitted_at	DATE	Date feedback was submitted

Your question is Preferred Visualization Tools. 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