Practice Interview Questions

Question	Tags	Company	Difficulty	Status

Dataford - Ace your Data Interview

PostgresSQL 14

Transaction Running Total

SQL+1

Medium

Given a table of transactions with transaction dates and amounts, write a SQL query to calculate the running total for each day.

For instance, if transactions on the first day total $20 and on the second day total$ 30, the output for the first day should be $20 a n d f o r t h$ 50 (which is 30 from the second).

Transaction Running Total

SQL+1

Medium

Given a table of transactions with transaction dates and amounts, write a SQL query to calculate the running total for each day.

For instance, if transactions on the first day total $20 and on the second day total$ 30, the output for the first day should be $20 a n d f o r t h$ 50 (which is 30 from the second).

e

s

e

c

o

n

d

d

a

y

20 and for the second day

20 an df or t h eseco n dd a y

20 from the first day plus

transactions table:

Column Name	Description
id	Identifier for each transaction
transaction_date	Date the transaction occurred
amount	The amount of the transaction

Example Output:

date	running_total
2022-01-01	300.00
2022-01-02	350.00
2022-01-03	700.00

Please log in to access this question and track your progress.

e

s

e

c

o

n

d

d

a

y

20 and for the second day

20 an df or t h eseco n dd a y

20 from the first day plus

transactions table:

Column Name	Description
id	Identifier for each transaction
transaction_date	Date the transaction occurred
amount	The amount of the transaction

Example Output:

date	running_total
2022-01-01	300.00
2022-01-02	350.00
2022-01-03	700.00

Please log in to access this question and track your progress.

633