Write an SQL query to find the users who made purchases in 3 consecutive months within a year.

SQL query to find users who purchased 3 consecutive months in a year

• Use a self join on the table to compare purchase months for each user

• Group by user and year, then filter for counts of 3 consecutive...read more