SQL Assessment Under Time Pressure | Dataford Interview Questions

Tell me about a time you ran out of time on a technical SQL assessment and how you handled it.

For the practical portion, use the supplied assessment session, question, and event data to summarize the final state of each question.

Output

One row per session question, including questions with no events.
Return session_id, question_id, question_order, final_event, elapsed_seconds, status, and previous_event.
Order by session_id, then question_order.

assessment_sessions

Column	Type	Description
session_idPK	INT	Assessment session identifier
candidate_name	VARCHAR(100)	Candidate name
started_at	TIMESTAMP	Session start timestamp
allocated_seconds	INT	Time allocated to the session

assessment_questions

Column	Type	Description
session_idPK	INT	Assessment session identifier
question_idPK	INT	Question identifier within the session
question_order	INT	Question sequence in the session

assessment_events

Column	Type	Description
event_idPK	INT	Event identifier
session_id	INT	Assessment session identifier
question_id	INT	Question associated with the event
event_type	VARCHAR(20)	Event action
event_at	TIMESTAMP	Event timestamp
seconds_remaining	INT	Remaining session time recorded by the event

Your question is SQL Assessment Under Time Pressure. 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.