A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

Finance wants a one-row-per-customer purchase snapshot for the lifetime-value model. For each user with at least one transaction, find their earliest and latest transaction_date and their total spending. Return the username and those three aggregates.

Summary

First purchase to last. The full spending arc.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.