SQL: Chatbot Then Human Within 24h | Dataford Interview Questions

Given a table of customer interactions, write a query to identify users who interacted with the chatbot and then called a human agent within 24 hours at [24]7.ai.

Use the customer_interactions table. A human-agent interaction must occur after the chatbot interaction and no later than 24 hours afterward.

Output

Return one row per qualifying user with the column user_id.
Sort results by user_id ascending.

Schema

customer_interactions

Column	Type	Description
interaction_idPK	INT	Unique identifier for the interaction
user_id	INT	Identifier of the customer
interaction_type	VARCHAR(40)	Interaction channel or event type
interaction_time	TIMESTAMP	Timestamp when the interaction occurred

Your question is SQL: Chatbot Then Human Within 24h. 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