SQL Whiteboarding and Coding | Dataford Interview Questions

Tell me about how you would approach a SQL whiteboarding problem and a separate coding problem under time pressure.

For the SQL portion, use the supplied users and posts tables. Write a query that demonstrates a clear, verifiable approach without including users who do not meet the required post threshold.

Output

One row per user with at least two published posts
Columns: user_id, username, published_post_count, and latest_published_at
Sort by published_post_count descending, then username ascending, with NULL usernames last

Schema

users

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

posts

Column	Type	Description
post_idPK	INT	Unique post identifier
user_id	INT	User who created the post
title	VARCHAR(120)	Post title
status	VARCHAR(20)	Post publication status
created_at	TIMESTAMP	Post creation timestamp

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