229. Time Between Repeat Purchases

hard microsoft

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

******

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

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

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

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 -
226 Customer Lifetime Value (CLV) and Segmentation microsoft hard -
227 Aggregate Sale Amounts per Customer microsoft hard -
228 Analyzing Sequential Purchase Behavior microsoft hard -
230 Customer Purchase Trend Analysis microsoft easy -