MySql动态行转列，网上找的sql语句，需要再添加字段，求帮忙谢谢大家

Question

SELECT
-> IFNULL(c1,'total') AS total,
-> SUM(IF(c2='B1',c3,0)) AS B1,
-> SUM(IF(c2='B2',c3,0)) AS B2,
-> SUM(IF(c2='B3',c3,0)) AS B3,
-> SUM(IF(c2='B4',c3,0)) AS B4,
-> SUM(IF(c2='total',c3,0)) AS total
-> FROM (
-> SELECT c1,IFNULL(c2,'total') AS c2,SUM(c3) AS c3
-> FROM tx
-> GROUP BY c1,c2
-> WITH ROLLUP
-> HAVING c1 IS NOT NULL
-> ) AS A
-> GROUP BY c1
-> WITH ROLLUP;

    这是在网上找的动态行转列sql语句，现在需要加个一行的所有科目平均分和总分排名，麻烦各位帮我个忙，谢谢大家了！！！

Answer 1

【18. Mysql 存储过程，实现动态数据透视 - CSDN App】http://t.csdnimg.cn/Xohzo
有你想要的