Re: sum and avg in same query

[Roland Bouman]

if your version supports subqueries (> 4.1) you can:

select sum(avg_score)
from (
select avg(score) as avg_score
from scores
group by ..
) as avg_score

but i dont know if this is a solution for your performance problem.

I hope it helps...