Closing the Books

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

Finance is closing April 2026 and needs a single revenue figure for the month. Each transaction's revenue is its `quantity` multiplied by the `total_amount` line total, so roll that up across every April 2026 transaction into one number.

Summary

April is done. Finance wants the number, and it isn't the one printed on the invoice line.

Practice This Problem

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