How to Identify Customers with Consecutive Purchases Over Months in SQL

This query identifies customers who have made purchases in three consecutive months.

Run this SQL QueryCopy Code

Use-case: A marketing team wants to reward loyal customers who consistently purchase every month with a special discount.