SELECT CASE WHEN KODPPD IS NULL
		THEN	'NEGERI SEMBILAN'
		ELSE	PPD
		END	AS 'KODPPD',

		KODPPD AS 'KODPPD',
		PPD AS 'PPD',

        JOHANA AS 'JOHANA'


	FROM ( SELECT KODPPD AS KODPPD, PPD,
 
    
    SUM(CASE WHEN A1 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A2 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A3 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A4 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A5 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A6 = '1' THEN 1 ELSE 0 END)  AS 'JOHANA'
   
     
    FROM TKHC 
    WHERE KODPPD <> 'ADMI'

	GROUP BY KODPPD WITH ROLLUP) AS CA


======================
QUERY KEDUA ****************


SELECT 
    SUM(CASE WHEN A1 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A2 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A3 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A4 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A5 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A6 = '1' THEN 1 ELSE 0 END)  AS 'UNIT_BERUNIFORM_JOHAN',
  
    SUM(CASE WHEN A1 = '2' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A2 = '2' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A3 = '2' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A4 = '2' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A5 = '2' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A6 = '2' THEN 1 ELSE 0 END)  AS 'UNIT_BERUNIFORM_NAIB_JOHAN',

    SUM(CASE WHEN A1 = '3' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A2 = '3' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A3 = '3' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A4 = '3' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A5 = '3' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A6 = '3' THEN 1 ELSE 0 END)  AS 'UNIT_BERUNIFORM_KETIGA',


    SUM(CASE WHEN A1 = '4' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A2 = '4' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A3 = '4' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A4 = '4' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A5 = '4' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN A6 = '4' THEN 1 ELSE 0 END)  AS 'UNIT_BERUNIFORM_ANGERAH_KHAS',


    SUM(CASE WHEN B1 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN B2 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN B3 = '1' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN B4 = '1' THEN 1 ELSE 0 END)  AS 'KELAB_PERSATUAN_KESENIAN_JOHAN',

    SUM(CASE WHEN B1 = '2' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN B2 = '2' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN B3 = '2' THEN 1 ELSE 0 END)  +
    SUM(CASE WHEN B4 = '2' THEN 1 ELSE 0 END)  AS 'KELAB_PERSATUAN_KESENIAN_NAIB_JOHAN'

-- SAMBUNG SETERUSNYA...

    FROM TKHC 
    WHERE KODPPD <> 'ADMI'


==========================================

<table>
<tr>
<td>UNIT_BERUNIFORM</td> <td>data1</td>  <td>data2</td> <td>data3</td> <td>data4</td>
</tr>
<tr>
<td>KELAB_PERSATUAN</td> <td>data1</td>  <td>data2</td> <td>data3</td> <td>data4</td>
</tr>
<tr>
<td>KELAB_PERSATUAN</td> <td>data1</td>  <td>data2</td> <td>data3</td> <td>data4</td>
</tr>
<tr>
<td>????????????</td> <td>data1</td>  <td>data2</td> <td>data3</td> <td>data4</td>
</tr>
</table>