SELECT cu.OKCFC1 as area, COUNT(CASE WHEN OKCFC3 like 'R01%' THEN OKCUNO END) as 'R01', COUNT(CASE WHEN OKCFC3 like 'R02%' THEN OKCUNO END) as 'R02', COUNT(CASE WHEN OKCFC3 like 'R03%' THEN OKCUNO END) as 'R03', COUNT(CASE WHEN OKCFC3 like 'R04%' THEN OKCUNO END) as 'R04', COUNT(CASE WHEN OKCFC3 like 'R05%' THEN OKCUNO END) as 'R05', COUNT(CASE WHEN OKCFC3 like 'R06%' THEN OKCUNO END) as 'R06', COUNT(CASE WHEN OKCFC3 like 'R07%' THEN OKCUNO END) as 'R07', COUNT(CASE WHEN OKCFC3 like 'R08%' THEN OKCUNO END) as 'R08', COUNT(CASE WHEN OKCFC3 like 'R09%' THEN OKCUNO END) as 'R09', COUNT(CASE WHEN OKCFC3 like 'R10%' THEN OKCUNO END) as 'R10', COUNT(CASE WHEN OKCFC3 like 'R11%' THEN OKCUNO END) as 'R11', COUNT(CASE WHEN OKCFC3 like 'R12%' THEN OKCUNO END) as 'R12', COUNT(CASE WHEN OKCFC3 like 'R13%' THEN OKCUNO END) as 'R13', COUNT(CASE WHEN OKCFC3 like 'R14%' THEN OKCUNO END) as 'R14', COUNT(CASE WHEN OKCFC3 like 'R15%' THEN OKCUNO END) as 'R15', COUNT(CASE WHEN OKCFC3 like 'R16%' THEN OKCUNO END) as 'R16', COUNT(CASE WHEN OKCFC3 like 'R17%' THEN OKCUNO END) as 'R17', COUNT(CASE WHEN OKCFC3 like 'R18%' THEN OKCUNO END) as 'R18', COUNT(CASE WHEN OKCFC3 like 'R19%' THEN OKCUNO END) as 'R19', COUNT(CASE WHEN OKCFC3 like 'R20%' THEN OKCUNO END) as 'R20', COUNT(CASE WHEN OKCFC3 like 'R21%' THEN OKCUNO END) as 'R21', COUNT(CASE WHEN OKCFC3 like 'R22%' THEN OKCUNO END) as 'R22', COUNT(CASE WHEN OKCFC3 like 'R23%' THEN OKCUNO END) as 'R23', 
COUNT(CASE WHEN OKCFC3 ='R' THEN OKCUNO END) as 'R' 
FROM MVXJDTA.OCUSMA as cu where (((cu.OKCUNO like 'V%') and (cu.OKCUNO not like 'V0%') 
and (cu.OKCUNO <>'COMMISSION')) 
and (cu.OKCUNM not like '**%')) 
and OKCUNO not like 'C%' 
GROUP BY cu.OKCFC1 ORDER BY OKCFC1<BR><font size='2'>Data prepare Complete . . . All Rows For Upload  -> [88]