SELECT CASE SGPG_GRA WHEN '非常适岗' THEN '4' WHEN '适岗' THEN '3' WHEN '基本适岗' THEN '2' WHEN '不适岗' THEN '1' END 适岗性, CASE YJ_GRA WHEN 'A' THEN '1' WHEN 'B' THEN '2' WHEN 'C' THEN '3' WHEN 'D' THEN '4' END 业绩评价, COUNT(NAME) FROM dw.dw_hr_sgxpg_test WHERE SUBSTR(YEARMONTH,1,4)=TO_CHAR(CURRENT_DATE,'YYYY') GROUP BY CASE SGPG_GRA WHEN '非常适岗' THEN '4' WHEN '适岗' THEN '3' WHEN '基本适岗' THEN '2' WHEN '不适岗' THEN '1' END 适岗性, CASE YJ_GRA WHEN 'A' THEN '1' WHEN 'B' THEN '2' WHEN 'C' THEN '3' WHEN 'D' THEN '4' END 业绩评价