帮忙看一下怎么编写？

SELECT name,
sum(case no when 01 then score else 0 END) as '监测01',
sum(case no when 02 then score else 0 END) as '监测02',
sum(case no when 03 then score else 0 END) as '监测03'
FROM `level` GROUP BY name;
注(name 为行政区，no为监测指标，score为监测分数，表明为level)