SQL and Python Coding Mix | Dataford Interview Questions

Solve two SQL questions and one Python question based on the provided data.

Use the supplied users, posts, and comments tables. The SQL answers should identify active users from January 2025 and select the highest-scoring post in each subreddit. Provide the Python answer separately using the requested input and output format.

Output

SQL question 1: one row per qualifying user, with username, post_count, and average_score, ordered by average_score descending and username ascending.
SQL question 2: one row per subreddit, with subreddit, post_id, title, score, and comment_count, ordered by subreddit ascending.
Python: return the requested output shape for the supplied data.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
username	VARCHAR(100)	Display username
created_at	TIMESTAMP	User creation timestamp

posts

Column	Type	Description
post_idPK	INT	Unique post identifier
user_id	INT	Author user identifier
subreddit	VARCHAR(100)	Community containing the post
title	VARCHAR(255)	Post title
score	INT	Net post score
created_at	TIMESTAMP	Post creation timestamp

comments

Column	Type	Description
comment_idPK	INT	Unique comment identifier
post_id	INT	Post receiving the comment
body	TEXT	Comment text
created_at	TIMESTAMP	Comment creation timestamp

Your question is SQL and Python Coding Mix. 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