Average Coach Response Time | Dataford Interview Questions

Given a table of message exchanges between Omada Health coaches and members, find the average response time for coaches, grouping by the day of the week.

Treat a coach message as a response only when the immediately preceding message in the same conversation was sent by a member. Ignore messages with a NULL sent_at value.

Output

One row per weekday with at least one qualifying coach response.
Columns: day_of_week and average_response_minutes, rounded to two decimal places.
Order weekdays Monday through Sunday. Rows with a NULL sent_at value are ignored.

Schema

coach_member_messages

Column	Type	Description
message_idPK	INTEGER	Unique identifier for the message
conversation_id	VARCHAR(100)	Identifier for the coach-member conversation
sender_type	VARCHAR(100)	Role of the message sender
sent_at	TIMESTAMP	Timestamp when the message was sent

Your question is Average Coach Response Time. Start with the requirements and the one table 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