We need to produce a query to return the total number of user visits between
two date ranges that span over two year e.g from 2009-04-29 to 2010-04-29.
My question is how can I compute the totals for each week within a query ?
2009-04-29 to 2009-05-06 100 visits
2009-05-07 to 2009-05-14 250 visits etc