SQL Case

Lifetime value with latest order

Produce one paid-order summary row per customer, including lifetime spend and the latest paid order.

What this task practices

Lifetime value with latest order 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.