Unfamiliar Schema Under Pressure | Dataford Interview Questions

How would you solve intermediate SQL questions involving an unfamiliar schema under time pressure at Dropbox?

Using the provided Dropbox schema, write one PostgreSQL query that summarizes January 2025 activity for every team. Include teams with no qualifying activity and classify each team based on its number of active users.

Output

One row per team with team_name, active_users, uploaded_bytes, latest_event_at, and activity_status
Include all teams, including teams with no qualifying events
Sort by active_users descending, then team_name ascending

Schema

teams

Column	Type	Description
team_idPK	INT	Unique Dropbox team identifier
team_name	VARCHAR(100)	Display name of the team

users

Column	Type	Description
user_idPK	INT	Unique Dropbox user identifier
team_id	INT	Team assigned to the user
full_name	VARCHAR(120)	User display name

file_events

Column	Type	Description
event_idPK	INT	Unique file event identifier
user_id	INT	User associated with the event
event_type	VARCHAR(30)	Type of file event
bytes	BIGINT	Bytes associated with the event
event_at	TIMESTAMP	Timestamp when the event occurred

Your question is Unfamiliar Schema Under Pressure. 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