select tag,exam_cnt_20,exam_cnt_21,concat(round((exam_cnt_21-exam_cnt_20)/exam_cnt_20*100,1),'%') rat,exam_cnt_rank_20,exam_cnt_rank_21,exam_cnt_rank_21-exam_cnt_rank_20 from (select tag,sum(if(yr=2020,cnt,0)) exam_cnt_20,sum(if(yr=2021,cnt,0)) exam_cnt_21, max(if(yr=2020,rk,0)) exam_cnt_rank_20,max...