We would like to find customers who have made 10 consecutive year purchases with us. The date range wouldn't be limited. Meaning, we are looking between the years of 2000 and 2015, so not limited to the past 10 years only.
A 10 year consecutive purchase would mean the patron purchased tickets each year between 2002-2011 for example. If a patron purchased each year between 2002-2007 (5 years), skipped 2008 and purchased each year between 2009-2013, (total of 11 years in length but two sets of 5 years) we would not want to include that person.
I hope that makes sense. Thoughts?