我用这命令时提示:函数名缺少)该如何解决,请大师帮忙
											SELECT zxdm, SUM(CASE WHEN kmdm = '06' THEN 报名人数 ELSE 0 END) AS [化学],SUM(CASE WHEN kmdm = '07' THEN 报名人数 ELSE 0 END) AS [生物学],SUM(CASE WHEN kmdm = '08' THEN 报名人数 ELSE 0 END) AS [历史],SUM(CASE WHEN kmdm = '09' THEN 报名人数 ELSE 0 END) AS [地理],FROM your_table GROUP BY zxdm										
					
	


 
											





 
	    

 
	


 
											