Table 1: msft_customers
******** ******* ***** *********, ********* ***** **, ****, ***, ******, *** *** **** **** ******.
********_**: ***, ****: *******, ***: ***, ******: *******, ****_****: ****
Question 226
Customer Lifetime Value (CLV) and Segmentation
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
***** ***** ******, ****_*********, ****_********, *** ****_*****, ***** * ************* *** ***** (** * ****** ** *******) ** ********* *** ******** ******** ***** (***) *** **** ********. *** *** ****** ** ********** ** *** ***** ******* ********* **** * ******** **** *** ***** *********, ********** ** *** ***** ****** ********** (****** * **** **** ** 25% ****** *** ******** *** **********). ************, ******* ********* **** ***** ********** ***** ** ***** ***: '**** *****', '****** *****', *** '*** *****'. *** *** ********* *** ********** *** ************: **** ***** (*** > $1000), ****** ***** ($500 < *** ≤ $1000), *** *** ***** (*** ≤ $500).
***********, ******* ******** **** *** ********** ******** ** ***** ******** ** ***** ** ********* ******* **********. ******** *** **** ******* ******* ******** *** **** *** *******.
************:
- ********* ******** ******** ***** (***): ******* *** *** *** **** ******** ***** ** ***** ***** ********* *** * ***** ***** ****** ** 25%.
- ******* *********: ********** ********* **** '**** *****', '****** *****', *** '*** *****' ******** ***** ** ***** ***.
- ******* ********** ********: *** **** *** *******, ******** *** **** ******* ******* ******** (*.*., *** ******** **** *** ******* ****** ** *********).
- ******* **** ********: **** ***** ****** ****** ******* *** ******** **, *** *******, *** *** **** ******* ******* ******** *** **** *******.
***********:
- ***
***********_****************** *** **** ***** ** **** *******. - ***** **** **
****_************* *** ************ **** ** *********. - ***** ****** ** * **** 25% ****** *** ********.
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.
15:00
Your results
Run your query to preview results here.