CREATE VIEW pay_stat as SELECT left(pay_status,10) as PP ,SUM( IF( payfor ='現場繳費', `final_cost`, 0 ) ) AS 現場繳費 ,SUM( IF( payfor ='刷卡', `final_cost`, 0 ) ) AS 刷卡 ,SUM( IF( payfor ='超商代碼', `final_cost`, 0 ) ) AS 超商代碼,SUM( IF( payfor ='虛擬帳號', `final_cost`, 0 ) ) AS 虛擬帳號 FROM `class_student` WHERE pay_status !='' group by PP order by pay_status ASC
