avgsal

I have a table named test and the columns are sal and name. i have tha following values name sal ---- ----- A 1 B 9 A 9 B 5 A 8 i need the 'name' which gives the max(avg(sal)). it means name 'A' gives the avg of 6 and name 'B' gives the avg of 7. now i...