SQL for Business Scenarios | Dataford Interview Questions

How would you write SQL queries for different business scenarios?

Use the provided TikTok creator, video, and event data. Write one PostgreSQL query that evaluates creators with at least two public videos published in June 2025 and measures their June event performance.

Output

One row per qualifying creator.
Columns: display_name, eligible_video_count, total_views, engagement_rate_pct, and creator_rank.
Include views, likes, and shares from June 2025 only. Calculate engagement rate as (likes + shares) / views * 100, rounded to two decimals.
Order by creator_rank, then creator_id ascending for deterministic ties.

Schema

creators

Column	Type	Description
creator_idPK	INT	Unique creator identifier
display_name	VARCHAR(100)	Creator display name

videos

Column	Type	Description
video_idPK	INT	Unique video identifier
creator_id	INT	Creator who published the video
published_at	DATE	Video publication date
privacy_status	VARCHAR(20)	Video visibility status

video_events

Column	Type	Description
event_idPK	INT	Unique event summary identifier
video_id	INT	Video associated with the event
event_date	DATE	Date of the event summary
event_type	VARCHAR(20)	Event category
event_count	INT	Number of events represented by the row

Your question is SQL for Business Scenarios. 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