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