The Transaction Breakdown

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

Domain

SQL

Difficulty

easy

Seniority

L4

Problem

Produce a single-row snapshot showing transaction counts at three time horizons: last 30 days, last 180 days, and all-time. One row, three numbers, used to illustrate acceleration trends on the exec dashboard.

Summary

Multiple time windows. One query. The business wants all of it at once.

Practice This Problem

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