Table 1: msft_customers
******** ******* ***** *********, ********* ***** **, ****, ***, ******, *** *** **** **** ******.
********_**: ***, ****: *******, ***: ***, ******: *******, ****_****: ****
Question 230
Customer Purchase Trend Analysis
Premium Access
Unlock this Microsoft interview question.
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
- 230+ interview questions
- Official solutions
- SQL, Python, and R tracks
********* * ***** ** ******* *** ***** ** ******** ******* *** **** ******** **** ***** **** ***** ************. ************, ******** ** *** ********'* ******** ** **********, **********, ** ************. *** **** ********, ******** **** ********* *** **** **** ** ***** ***** *********. ***** *** ***** ** '**********' ** **** ********** ******** ** ******* **** *** ********, '**********' ** **** ** ****, *** '************' *********. *** ****** ****** ******* *** ********'* **** *** *** ********** ******** *****.
*****:
- *** *** *** ******** ** ******* *** ******* ******** ****** **** *** ******** ****.
- ****** **** **** *** **** ***** ************ *** **** ******** *** **********.
- *** **** ********** ** ********** *** ******** ***** ***** ** *** ***********.
******** ****** *******:
- ******** ****
- ******** ***** (**********, **********, ** ************)
Table 2: msft_products
***** *********** ** ********, **** ** ******* **, ****, *****, *** ********.
*******_**: ***, *******_****: *******, *****: *******, ********: *******
Table 3: msft_sales
******* ******* ** ***** ************, ********* *** **** **, ******** **, ******* **, **** ** *** ***********, *** *** ******** ** ******** ****.
****_**: ***, ********_**: ***, *******_**: ***, ****_****: ****, ********: ***
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
Copied
Expected results
Submit a query to compare against expected output.
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.
5:00
Your results
Run your query to preview results here.