MongoDB Fit and Motivation | Dataford Interview Questions

Why do you want to join MongoDB?

Answer this as a SQL interview exercise by producing the requested result set from the tables below. Keep the output focused and deterministic.

Output

One row per candidate, with the columns candidate_name, motivation_score, and primary_reason
Include only candidates with at least one completed interview stage
Sort by motivation_score descending, then candidate_name ascending

candidates

Column	Type	Description
candidate_idPK	INT	Unique candidate identifier
candidate_name	VARCHAR(100)	Candidate full name
role_applied_for	VARCHAR(100)	Role the candidate applied for
source	VARCHAR(50)	Recruiting source

interview_stages

Column	Type	Description
stage_idPK	INT	Unique stage identifier
candidate_id	INT	References candidates.candidate_id
stage_name	VARCHAR(50)	Interview stage name
completed_at	DATE	Date the stage was completed

interview_responses

Column	Type	Description
response_idPK	INT	Unique response identifier
candidate_id	INT	References candidates.candidate_id
response_type	VARCHAR(20)	Response sentiment type
response_text	TEXT	Free-text response

Your question is MongoDB Fit and Motivation. 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.