虽然优化很差,但浅显易懂😂 select t20.tag ,exam_cnt_20 , exam_cnt_21, concat(round((exam_cnt_21 - exam_cnt_20)*100/exam_cnt_20,1),"%") growth_rate ,exam_cnt_rank_20 ,exam_cnt_rank_21, if(exam_cnt_rank_21 > exam_cnt_rank_20, exam_cnt_rank_21 - exam_cnt_rank_20, - (exam_cnt_rank_20 - exam_cnt_rank_21...