Ranking according to student average

[celoaga]

Hi There,


i want to prepare a query which gives me the ranking of the classroom according to their average. (also there are classrooms in the table, if possible, query should consider the grades) you can see the attached sample document. thank you for your help.

[June7]

So you need to rank within each grade group? Review: http://allenbrowne.com/ranking.html