SQL and R in a Project Context | Dataford Interview Questions

Describe a project where you used SQL and R together to produce an analysis.

For this exercise, use the provided project, tool, and output records to identify qualifying projects and summarize their recorded outputs.

Output

One row per project that used both SQL and R and has at least one recorded output
Columns: project_name, output_count, latest_output_date, and output_status
Sort by output count descending, latest output date descending, then project name ascending

analysis_projects

Column	Type	Description
project_idPK	INT	Unique analysis project identifier
project_name	VARCHAR(100)	Name of the analysis project
owner_team	VARCHAR(80)	Team responsible for the project
started_on	DATE	Project start date

project_tools

Column	Type	Description
project_tool_idPK	INT	Unique project-tool record identifier
project_id	INT	Referenced analysis project
tool_name	VARCHAR(40)	Tool used in the project

analysis_outputs

Column	Type	Description
output_idPK	INT	Unique analytical output identifier
project_id	INT	Referenced analysis project
output_type	VARCHAR(50)	Type of analytical output
completed_on	DATE	Date the output was completed
notes	VARCHAR(150)	Optional output note

Your question is SQL and R in a Project Context. Start with the requirements and the three 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.