Two Names on the Ledger

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

Domain

SQL

Difficulty

easy

Seniority

L4

Problem

Finance is reconciling revenue for two customers, alice and aaron42, and wants to see how their combined spend builds up transaction by transaction. Going through their transactions from the earliest ID to the latest, return each transaction's ID, the user, its amount, and the combined revenue accumulated through that transaction.

Summary

Two accounts. One ledger. Watch the spend stack up.

Practice This Problem

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