首先是查处平均成绩并降序排序，这一步小弟自己完成了，代码如下select score.`学号`, AVG(score.`成绩`), student.`姓名`
from score, kecheng, student
where score.`课程编号`=kecheng.`课程编号` AND student.`学号`=score.`学号`
group by student.`姓名`
order by avg(score.`成绩`) desc第二，就是查询自己按平均成绩排序的名次。这个该如何实现，哪位大哥帮哈小弟，万分感谢！！！！
from score, kecheng, student
where score.`课程编号`=kecheng.`课程编号` AND student.`学号`=score.`学号`
group by student.`姓名`
order by avg(score.`成绩`) desc第二，就是查询自己按平均成绩排序的名次。这个该如何实现，哪位大哥帮哈小弟，万分感谢！！！！
from (
select `学号`,AVG(`成绩`) as a
from score
group by `学号`
) a
where a.a>(select AVG(`成绩`) from score where `学号`='自己')
set @a=0;
select *,@a:=@a+1 as mc from (
select * from view order by view) a