Consecutive Purchase Customers | Dataford Interview Questions

You have a table of customer orders. Write a query to identify customers who have made a purchase in three consecutive months.

Treat multiple orders within the same calendar month as one purchase month. Ignore orders with a missing customer or order date.

Output

customer_orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer who placed the order
order_date	DATE	Date when the order was placed
order_amount	DECIMAL(10,2)	Total order amount

Your question is Consecutive Purchase Customers. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You have a table of customer orders. Write a query to identify customers who have made a purchase in three consecutive months.

Treat multiple orders within the same calendar month as one purchase month. Ignore orders with a missing customer or order date.

customer_orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer who placed the order
order_date	DATE	Date when the order was placed
order_amount	DECIMAL(10,2)	Total order amount

Your question is Consecutive Purchase Customers. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.