226. Customer Lifetime Value (CLV) and Segmentation

hard microsoft

**********************************, **********************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************

*************

  1. ******************************************************************************************************************************************
  2. ***********************************************************************************************************************
  3. ********************************************************************************************************************************************************
  4. *********************************************************************************************************************************************

************

  • *********************************************************************
  • *********************************************************************
  • ***********************************************

Table 1: msft_customers

**************************************************************************************************


***************************************************************************

Table 2: msft_products

*****************************************************************************


*************************************************************************

Table 3: msft_sales

**************************************************************************************************************************************************


*******************************************************************************

Last Submission postgres

Expected results


More Microsoft questions

ID Title Level FTPR
218 Total Amount Spent by Each Customer microsoft medium -
219 Inactive Customers in the New Year of 2024 microsoft medium -
220 Most Expensive Product in Each Category microsoft hard -
221 Customers With More Than 5 Products in a Single Transaction microsoft hard -
222 Product Sales Ranking Within Categories microsoft hard -
223 Cumulative Total Sales by Day microsoft hard -
224 Categories with High Average Product Price microsoft medium -
225 Customer Behavior Analysis microsoft hard -
227 Aggregate Sale Amounts per Customer microsoft hard -
228 Analyzing Sequential Purchase Behavior microsoft hard -
229 Time Between Repeat Purchases microsoft hard -
230 Customer Purchase Trend Analysis microsoft easy -