thumann

SELECT character_faction as faction,avg(character_level)as averageFROM armory_rankingWHERE character_gamelevel = '70'GROUP BY character_factionORDER BY average DESC/* Result:faction		averageAlliance 	1990.2857Horde	 	1986.6923*/SELECT character_region as region,avg(character_level)as world_averageFROM armory_rankingWHERE character_gamelevel = '70'GROUP BY character_regionORDER BY world_average DESC/* Result:region		world_averageUS 		1990.2857EU 		1986.6923*/