Re: Query with Average on COUNT(*) values?

2004-12-13 Thread Onemarty
Thanks, Shawn, this helped a lot, although I'm not there yet. (..and you got it absolutely right, I just couldn't explain it correctly). I tried to execute this in OpenOffice, but it seems to use a function called executeQuery(). I don't know if it's part of OpenOffice or a library routine in th

Re: Query with Average on COUNT(*) values?

2004-12-13 Thread SGreen
It's not a hard as you are making it out to be. You are already able to "Group" you data on a value that breaks your data into "useful chunks". In your case you already figured out one way to differentiate one hour from another and one weekday from another. (The value 'Sun 00' is different tha

Query with Average on COUNT(*) values?

2004-12-13 Thread Onemarty
For me, a Newbie, this is a tricky one. I've been through the manual and this archive, but haven't found a solution. Could someone of you experienced please help? Is it possible to make this query in one single SQL-statement? (Using MySQL 4.0.15 - If this can be done smarter in 4.1.x, please she