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

2004-12-13 Thread Onemarty
lt into it. You have to specifically > ask for that sorting to NOT happen if you don't want it). Now that you no > longer need it, you can also drop the temp table: > > DROP TEMPORARY TABLE tmpStats; > > HTH, > Shawn Green > Database Administrator > Unimin Corp

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