select '女' as 性别,AVG(GRADE)  from STSCORE where sex='F'  group by SEX

union all

select '男' as 性别,AVG(GRADE)  from STSCORE where sex='M'  group by SEX

select "男" as SEX   ,AVG(GRADE)  from STSCORE where sex='F'  group by SEX

union

select "女" as SEX  ,AVG(GRADE)  from STSCORE where sex='M'  group by SEX

select (case when SEX='F' then '女' else '男' END) [性别]  ,AVG(GRADE)  [平均分] from STSCORE group by sex

试下这个结构

1)SQL SERVER 测试可以用

<

SELECT  CASE SEX  WHEN 'F' Then '女'  WHEN 'M' Then '男'  END AS 性别,  AVG(GRADE) AS 平均成绩  FROM STSCORE  GROUP BY SEX

>

2)SQL SERVER 与Excel 都测试了可以用

<

SELECT '女' AS 性别,AVG(GRADE) AS 平均成绩 FROM STSCORE WHERE SEX='F' GROUP BY SEX

UNION ALL

SELECT '男' AS 性别,AVG(GRADE) AS 平均成绩 FROM STSCORE WHERE SEX='M' GROUP BY SEX

>

3)还可以这样,但方向与你的不一致

<

SELECT SUM(IIF(SEX='F',GRADE,0))/SUM(IIF(SEX='F',1,0)) AS '女' 

,SUM(IIF(SEX='M',GRADE,0))/SUM(IIF(SEX='M',1,0)) AS '男'

FROM STSCORE

>