Using SQL for Complex Problems | Dataford Interview Questions

Describe a time when you used SQL to solve a complex data problem.

For this exercise, use the provided Docker organization, membership, and activity-event tables. Write a query that identifies organizations with at least two active members and two activity events during January 2025.

Output

One row per qualifying organization
Columns: organization_name, active_members, total_events, successful_events, failed_events, failure_rate_pct, and top_event_type
Include the most frequent event type, breaking ties alphabetically
Order by failure rate descending, then organization name ascending

Schema

organizations

Column	Type	Description
organization_idPK	INT	Unique organization identifier
organization_name	VARCHAR(100)	Docker organization name

organization_members

Column	Type	Description
membership_idPK	INT	Unique membership record identifier
organization_id	INT	Organization associated with the membership
member_id	INT	Member identifier
membership_status	VARCHAR(20)	Current membership status

activity_events

Column	Type	Description
event_idPK	INT	Unique activity event identifier
organization_id	INT	Organization associated with the event
member_id	INT	Member responsible for the event, when available
event_type	VARCHAR(30)	Type of activity recorded
outcome	VARCHAR(20)	Event outcome
event_timestamp	TIMESTAMP	Timestamp when the event occurred

Your question is Using SQL for Complex Problems. 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