Top N Query with Complex Criteria | Dataford Interview Questions

Given a specific table structure, write a query to fetch the top N records based on a complex criteria.

Use the provided tables and evaluate records through 2025-03-31. Return entities with at least two active terminals and at least 1,000 in qualifying net volume. Rank them by net volume descending, then March-over-February growth descending, then entity ID ascending.

Output

One row per selected entity with columns entity_id, entity_name, net_volume, active_terminal_count, and growth_pct
Include only the top three qualifying entities
Sort by the stated ranking rules

Schema

entities

Column	Type	Description
entity_idPK	INT	Unique entity identifier
entity_name	VARCHAR(100)	Entity display name

terminals

Column	Type	Description
terminal_idPK	INT	Unique terminal identifier
entity_id	INT	Owning entity
activated_at	DATE	Date the terminal became active
deactivated_at	DATE	Date the terminal became inactive

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
entity_id	INT	Entity associated with the transaction
terminal_id	INT	Terminal that processed the transaction
occurred_at	DATE	Transaction date
amount	NUMERIC(12,2)	Signed transaction amount
status	VARCHAR(20)	Transaction status

Your question is Top N Query with Complex Criteria. 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