數(shù)據(jù)庫字段如下:

學(xué)生成績表
select examNo, stuNo, (chinese+english+math)/3 as avg_score from tbl_exam_data ORDER BY avg_score desc;
數(shù)據(jù)庫字段如下:
select examNo, stuNo, (chinese+english+math)/3 as avg_score from tbl_exam_data ORDER BY avg_score desc;