如何显示排序依据和分组依据

 SELECT DISTINCT
        GradeID, Division, vchSubject, Topic, competency, AVG(Column3) as 'Total',
        AVG(Played_Count) as 'KidCount',
        (AVG(Played_Count) / AVG(Column3)) * 100 as 'Percents'
   FROM (
         SELECT UserID, [User Name], GradeID, Division,
                vchSubject,stable.vchCompetency as Topic,
                stable.vchComptencyDesc as competency,
                column3, isnull(column4,0) as 'Played_Count',
                (isnull(column4, 0) / column3 ) * 100 as 'Percents'
           FROM
                (
                --some code
                ) as Mtable4
  GROUP BY Mtable4.GradeID, Division, vchSubject, Topic, competency
  ORDER BY Percents

我是sql查询的新手，发现很难分组和订购；它给了error。有人可以帮助我解决。