Thanks for the reply gsquared.

The number of rows returned are correct... but somehow the count is messed up. I am trying to figure out why. The total number of users matching the date range is not the same as the total of all users returned by city/group.

Let me first try to understand what does cross join do?