/*mysql统计各科成绩、平均分、总分 石正先 13611326258
*/
select name as 名字 ,
sum(if(Subject='语文',Fraction,0)) as 语文,
sum(if(Subject='数学',Fraction,0))as 数学,
sum(if(Subject='英语',Fraction,0))as 英语,
round(AVG(Fraction),2) as 平均分,
SUM(Fraction) as 总分
from t_score group by name UNION
select name as 名字 ,
sum(语文) Chinese,
sum(数学) Math,
sum(英语) English,
round(AVG(总分),2)as 平均分,
sum(总分) score
from(
select 'TOTAL' as name,
sum(if(Subject='语文',Fraction,0)) as 语文,
sum(if(Subject='数学',Fraction,0))as 数学,
sum(if(Subject='英语',Fraction,0))as 英语,
SUM(Fraction) as 总分
from t_score group by Subject )t
/*mysql统计各科成绩、平均分、总分 石正先 13611326258
*/
select name as 名字 ,
sum(if(Subject='语文',Fraction,0)) as 语文,
sum(if(Subject='数学',Fraction,0))as 数学,
sum(if(Subject&