SQL Case

Identity and access: lifetime and latest event

Identity and access: Return one row per principal with completed lifetime value and latest completed event.

What this task practices

Identity and access: lifetime and latest event is a sql case interview exercise that trains prompt interpretation, explicit assumptions, a concrete response, and a clear explanation of tradeoffs. The catalog marks it as hard difficulty. It focuses on Data Reasoning, Performance Analysis, Technical Reasoning. The signed-in workspace provides the tools for the round and evaluates the attempt against task-specific criteria. Reference solutions, hidden checks, evaluator instructions, and candidate work remain private.