SQL Then Python Parity | Dataford Interview Questions

Write SQL code to produce a desired output, then write programming to do the same thing (Python or pseudo code).

Use the provided users and messages tables. Return users with at least two Slack messages sent during January 2025, then reproduce the same result with Python using the function signature summarize_messages(users, messages).

Output

One row per qualifying user with user_id, user_name, total_messages, and latest_message_at.
Include only users with at least two messages in January 2025.
Order by total_messages descending, latest_message_at descending, then user_id ascending.

Schema

users

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

messages

Column	Type	Description
message_idPK	INT	Unique message identifier
user_id	INT	Authoring user identifier
channel_name	VARCHAR(100)	Slack channel containing the message
sent_at	TIMESTAMP	Message creation timestamp

Your question is SQL Then Python Parity. 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