Hi,

I'd like to get a feel for repeat customers, and how frequently they repeat.
Can someone help me with SQL to create a report that gives me, for a specified time period, how many customers have placed 1 order; 2 orders; 3 orders; 4 orders...

The problem for me is that you have to use email address and not customerid (thanks to anonymous checkout).

Also, I know this won't be perfect because some people use different email addresses, but I think that comes closer than using the billing name & address (because people move).

This kind of SQL is too complex for me. All suggestions are welcome!

edit: I don't necessarily want to see individual customers, but just get overall counts. I can dive down to individuals later.