Monthly Reset Cumulative Sales | Dataford Interview Questions

Compute cumulative sales by store, resetting to 0 whenever a new month starts. Write the query.

Treat each row as one store sale. Include nullable sale amounts as zero for cumulative calculations.

Output

One row per sale, with store_id, sale_date, sale_amount, and cumulative_sales.
Cumulative values restart for each store and calendar month.
Order by store_id, sale_date, and sale_id.

store_sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale
store_id	VARCHAR(20)	Store associated with the sale
sale_date	DATE	Date of the sale
sale_amount	NUMERIC(12,2)	Sale amount, which may be NULL

Your question is Monthly Reset Cumulative Sales. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Compute cumulative sales by store, resetting to 0 whenever a new month starts. Write the query.

Treat each row as one store sale. Include nullable sale amounts as zero for cumulative calculations.

One row per sale, with store_id, sale_date, sale_amount, and cumulative_sales.
Cumulative values restart for each store and calendar month.
Order by store_id, sale_date, and sale_id.

store_sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale
store_id	VARCHAR(20)	Store associated with the sale
sale_date	DATE	Date of the sale
sale_amount	NUMERIC(12,2)	Sale amount, which may be NULL

Your question is Monthly Reset Cumulative Sales. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.