MSSql改Mysql

SELECT
    *
FROM
    (SELECT
        left(charge,4) as charge,
        date(stattime) as stattime,
        count(*) as num
    FROM
        Table
    WHERE
        ((left(charge,3)='spc' or left(charge,3)='spw'  or left(charge,3)='spm')) AND
        stattime>='2011-06-01'
    GROUP BY
        left(charge,4),
        date(stattime) 
    ) a pivot (max(num) for charge in (spca,spcb,spcc,spcd,spwb,spma,spmb,spmc,spmd)) b