SELECT
SUM(CAST ( totalClassHour AS DECIMAL ( 10, 0 ) )) AS totalClassHour,
SUM (CAST (classHour AS DECIMAL ( 10, 0 ))) AS classHour,
cast(( SUM (cast (classHour AS decimal(10,0))) / SUM (cast (totalClassHour AS decimal(10,0) )) * 100) AS decimal(10,0)) AS complete
FROM sys_police AS p, policeAssessment AS ps WHERE p.jinghao= ps.jinghao
and ps.jinghao='0201'