Write a query using a Common Table Expression (CTE) that shows the cumulative total sales amount by day for the current year. Hint: Use a CTE for cumulative sum and GROUP BY for monthly aggregation.

Question 223

Cumulative Total Sales by Day

Premium Access

Unlock this Microsoft interview question.

230+ interview questions
Official solutions
SQL, Python, and R tracks

***** * ***** ***** * ****** ***** ********** (***) **** ***** *** ********** ***** ***** ****** ** *** *** *** ******* ****.
****: *** * *** *** ********** *** *** ***** ** *** ******* ***********.

Table: msft_sales

******* ******* ** ***** ************, ********* *** **** **, ******** **, ******* **, **** ** *** ***********, *** *** ******** ** ******** ****.

****_**: ***, ********_**: ***, *******_**: ***, ****_****: ****, ********: ***

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

15:00

Timer

Your results

Run your query to preview results here.

More Microsoft Questions

Browse Company Set

Question	Level	FTPR
#218. Total Amount Spent by Each Customer	Medium
#219. Inactive Customers in the New Year of 2024	Medium
#220. Most Expensive Product in Each Category	Hard
#221. Customers With More Than 5 Products in a Single Transaction	Hard
#222. Product Sales Ranking Within Categories	Hard
#224. Categories with High Average Product Price	Medium
#225. Customer Behavior Analysis	Hard
#226. Customer Lifetime Value (CLV) and Segmentation	Hard
#227. Aggregate Sale Amounts per Customer	Hard
#228. Analyzing Sequential Purchase Behavior	Hard
#229. Time Between Repeat Purchases	Hard
#230. Customer Purchase Trend Analysis	Easy