Running Balance per Account

Return each transaction with the running balance of its account in id order. Order by id.

Table schema

Transactions(id INT PRIMARY KEY, account VARCHAR(5), amount INT)

Sample data

id | account | amount
1 | A | 100
2 | A | -30
3 | B | 50
4 | A | -90
5 | B | -20