SQL and Python Data Work | Dataford Interview Questions

Tell me about your experience using SQL and Python to solve data analysis problems.

For the hands-on SQL portion, use the provided users and analytics_events tables to summarize valid January 2025 activity for every user. Return one row per user, including users without qualifying events, and sort by total event value descending and user ID ascending.

Output

Columns: user_id, user_name, qualifying_event_count, conversion_count, total_event_value, latest_event_at
Include only January 2025 events with supported event types and nonnegative or NULL event values.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name
email	VARCHAR(255)	User email address

analytics_events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	INT	User associated with the event
occurred_at	TIMESTAMP	Event timestamp
event_type	VARCHAR(50)	Type of analytics event
channel	VARCHAR(50)	Acquisition or interaction channel
event_value	DECIMAL(10,2)	Optional numeric value associated with the event

Your question is SQL and Python Data Work. Start with the requirements and the two 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