You're exactly right, that's an important point that I neglected when putting together my example. Good catch.
On Mar 18, 2010, at 11:27 AM, Chris W wrote: > I think I would change the math. Since there are several days in there where > there are no hits, that should in my opinion count against the average. So > instead of dividing by count(h.AccountID), I would divide by 7 which would > change the values to about... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org