Write a query to analyze the behavior of repeat purchases for each product. Specifically, calculate the average time (in days) between successive purchases of the same product by the same customer. Include only customers who have purchased the same product more than once and ord…

Question 229

Time Between Repeat Purchases

Premium Access

Unlock this Microsoft interview question.

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

***** * ***** ** ******* *** ******** ** ****** ********* *** **** *******. ************, ********* *** ******* **** (** ****) ******* ********** ********* ** *** **** ******* ** *** **** ********. ******* **** ********* *** **** ********* *** **** ******* **** **** **** *** ***** *** ****** ** *** ******* ****. *** ****** ****** **** *** ******* ****, ******** ****, *** *** ******* **** ******** ******* ***** ********* ** **** *******.

*****:

*** *** *** ******** ** *** *** **** **** ** *** ******** ******** ** *** **** ******* ** *** **** ********.
********* *** ********** ** **** ******* ********** *********.
*** *** ** **** *** ******* **** ******** *** **** *******/******** ****.
****** ** ******* **** ********* **** **** **** *** ******** ** *** **** *******.

******** ****** *******:

******* ****
******** ****
******* **** ******** (** ****)

Table 1: msft_customers

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

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

Table 2: msft_products

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

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

Table 3: 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
#223. Cumulative Total Sales by Day	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
#230. Customer Purchase Trend Analysis	Easy