SQL average AVG function

[Gwizard]

I have an access query that computes an average and then finds the max value of each of these averages using stored procedures.

how do I do this as the version of sql I am using now says that MAX(AVG(hits)) is invalid.

SELECT member,memtype,avg(hits)
FROM MEMBERS
GROUP BY member,memtype

How do I work out the max average and ideas

 

[swampBoogie]

select max(blast)
from (SELECT avg(hits) as blast
FROM MEMBERS
GROUP BY member,memtype) as dt

 

[Gwizard]

Didn't quite work I am using sql anywhere,I will have to fiddle around with the syntax.

Thanks