Grouping a bunch of rows together and wanting to find the average of the count. Logic is something like "SELECT AVG(COUNT(*)) FROM table GROUP BY field". That obviously doesn't work, anybody know a handy way to do this? I can always loop through with my script and do the math there, but I am curious if this can be done completely with SQL.
Eric Jensen .===================================. | This has been a P.L.U.G. mailing. | | Don't Fear the Penguin. | | IRC: #utah at irc.freenode.net | `==================================='
