I need to know the rate of growth for the past five years. Essentially how many new customers were added last year (or season), and the year before, and before, etc. Any suggestions on a query? thanks!
I agree with Ryan - it depends on how you define "customer". Is it purely someone that purchases a ticket or do you include web site registrants without a ticket purchase? I suspect that once that definition has been made, the code itself to determine numbers is relatively early.
Accuracy of numbers could be influenced by how diligently you do your deduping!
Martin