Group by Totals with Top N Ranking | Dataford Interview Questions

Solve a mix of coding and SQL questions covering core operations like group by, having, rank, CTEs, and distinct.

Implement the coding portion using the function below. Aggregate records by (category, group), count distinct members, sum values, filter groups by minimum_total, rank qualifying groups within each category, and keep the top top_n groups per category. Sort results by category, rank, and group.

Input and Output

rows is a list of dictionaries with string keys category, group, member, and integer value. Return a list of dictionaries containing category, group, distinct_members, total_value, and rank.

Constraints

0 <= len(rows) <= 10^5
Each row contains string values for category, group, and member
value is an integer
1 <= top_n <= 10^5
Groups qualify when total_value >= minimum_total

Function Signature

def analyze_records(rows, minimum_total, top_n):

Whenever you're ready, walk me through your approach or go straight to the code. The requirements are in the Question tab.

Problem

Solve a mix of coding and SQL questions covering core operations like group by, having, rank, CTEs, and distinct.

Input and Output

Constraints

0 <= len(rows) <= 10^5
Each row contains string values for category, group, and member
value is an integer
1 <= top_n <= 10^5
Groups qualify when total_value >= minimum_total

Function Signature

def analyze_records(rows, minimum_total, top_n):

Whenever you're ready, walk me through your approach or go straight to the code. The requirements are in the Question tab.