SQL for Client Performance Insights | Dataford Interview Questions

Write a SQL query to analyze operational performance by client segment at EXOS, including joins between client, activity, and satisfaction tables, and summarize key metrics by month.

Use the provided tables and include activities with a matching client. Satisfaction data may be missing. Report one row per segment and activity month.

Output

Columns: segment, activity_month, activity_count, active_client_count, avg_duration_minutes, avg_satisfaction_score, satisfaction_response_pct, previous_month_activity_count, activity_change_pct
Include the requested monthly segment metrics, ordered by segment, then activity_month.

Schema

clients

Column	Type	Description
client_idPK	INT	Unique client identifier
client_name	VARCHAR(100)	Client organization name
segment	VARCHAR(30)	Client segment

activities

Column	Type	Description
activity_idPK	INT	Unique activity identifier
client_id	INT	Client associated with the activity
activity_type	VARCHAR(40)	Operational activity type
activity_at	TIMESTAMP	Activity timestamp
duration_minutes	INT	Activity duration in minutes

satisfactions

Column	Type	Description
satisfaction_idPK	INT	Unique satisfaction response identifier
activity_id	INT	Activity evaluated by the response
satisfaction_score	INT	Satisfaction rating from 1 to 5
response_channel	VARCHAR(30)	Channel used to submit feedback

Your question is SQL for Client Performance Insights. 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.

Problem