Group By

SELECT TableGuild.ID IdGuild,AVG(GuildMembers.CharLevel) MediaLevel,TableGuild.Lvl LevelGuild,COUNT(GuildMembers.GuildID) TotalMenbFROM OPTI_NUT_SHARD.dbo._Guild as TableGuild,OPTI_NUT_SHARD.dbo._GuildMember as GuildMembersWHEREGuildMembers.GuildID = TableGuild.IDGROUP BY TableGuild.ID,ORDER BY LevelGuild DESC,TotalMenb DESC,MediaLevel DESC

Porem está dando error
se eu tirar o TableGuild.Lvl LevelGuild, pega normalmente