SELECT character_faction as faction,avg(character_level)as average
FROM armory_ranking
WHERE character_gamelevel = '70'
GROUP BY character_faction
ORDER BY average DESC

/* Result:
faction		average
Alliance 	1990.2857
Horde	 	1986.6923
*/


SELECT character_region as region,avg(character_level)as world_average
FROM armory_ranking
WHERE character_gamelevel = '70'
GROUP BY character_region
ORDER BY world_average DESC

/* Result:
region		world_average
US 		1990.2857
EU 		1986.6923
*/