Managing a Complex Data Project | Dataford Interview Questions

Tell me about a complex data project you managed from inception to final presentation, including scope, milestones, and outcome.

For this SQL exercise, use the supplied project, milestone, and presentation records to produce a concise project-level summary.

Output

One row per project, including projects without milestones or a final presentation.
Return project_id, project_name, manager_name, scope_description, milestone_count, completed_milestones, final_presentation_date, and final_outcome.
Treat missing milestone counts as zero, and show missing presentation details as NULL.
Order by project_id ascending.

projects

Column	Type	Description
project_idPK	INT	Unique project identifier
project_name	VARCHAR(255)	Project name
manager_name	VARCHAR(255)	Project manager
scope_description	VARCHAR(500)	Brief description of project scope

project_milestones

Column	Type	Description
milestone_idPK	INT	Unique milestone identifier
project_id	INT	Referenced project
milestone_name	VARCHAR(255)	Milestone name
status	VARCHAR(50)	Milestone status
milestone_date	DATE	Planned or actual milestone date

project_presentations

Column	Type	Description
presentation_idPK	INT	Unique presentation identifier
project_id	INT	Referenced project
presentation_type	VARCHAR(50)	Presentation type
presentation_date	DATE	Date of presentation
outcome	VARCHAR(500)	Presentation outcome

Your question is Managing a Complex Data Project. 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.