Top 5% Active Workspaces SQL | Dataford Interview Questions

Write a SQL query to find the top 5% of active Airtable workspaces based on weekly active users, partitioned by industry.

Use the activity week from 2025-02-03 through 2025-02-09. Include active workspaces with no activity, treating their weekly active user count as zero.

Output

One row per selected workspace with industry_name, workspace_id, workspace_name, weekly_active_users, and top_5_percent_bucket.
Include only the highest 5% within each industry, using a deterministic workspace ID tie-breaker.
Sort by industry_name, descending weekly_active_users, then workspace_id.

Schema

industries

Column	Type	Description
industry_idPK	INT	Unique industry identifier
industry_name	VARCHAR(100)	Industry assigned to a workspace

workspaces

Column	Type	Description
workspace_idPK	INT	Unique Airtable workspace identifier
workspace_name	VARCHAR(150)	Airtable workspace name
industry_id	INT	Reference to the workspace industry
is_active	BOOLEAN	Whether the workspace is currently active

workspace_activity

Column	Type	Description
activity_idPK	INT	Unique activity event identifier
workspace_id	INT	Workspace associated with the activity
user_id	VARCHAR(50)	User who generated the activity event
activity_date	DATE	Date of the activity event

Your question is Top 5% Active Workspaces SQL. 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