/// SUMMARY NODE PER POJECT

SELECT trx,JENIS_PROJECT,COUNT(node) as node from tb_mdu where fix_scrap='FIXED SCRAP' group by trx,JENIS_PROJECT
union all
SELECT trx,JENIS_PROJECT,COUNT(rk) as node from tb_hw group by trx,JENIS_PROJECT
union all
SELECT trx,JENIS_PROJECT,COUNT(rk) as node from tb_ZTE group by trx,JENIS_PROJECT
union all
SELECT trx,JENIS_PROJECT,COUNT(rk) as node from tb_FH group by trx,JENIS_PROJECT
UNION ALL
SELECT 'ALL','TOTAL',SUM(T1.NODE) FROM 
(
SELECT trx,JENIS_PROJECT,COUNT(node) as node from tb_mdu where fix_scrap='FIXED SCRAP' group by trx,JENIS_PROJECT
union all
SELECT trx,JENIS_PROJECT,COUNT(rk) as node from tb_hw group by trx,JENIS_PROJECT
union all
SELECT trx,JENIS_PROJECT,COUNT(rk) as node from tb_ZTE group by trx,JENIS_PROJECT
union all
SELECT trx,JENIS_PROJECT,COUNT(rk) as node from tb_FH group by trx,JENIS_PROJECT
) T1



----------- BIKIN TABLE PARAMTER
SELECT trx,JENIS_PROJECT,WITEL,STO, COUNT(node) as node from tb_mdu where fix_scrap='FIXED SCRAP' group by trx,JENIS_PROJECT,WITEL,STO
union all
SELECT trx,JENIS_PROJECT,WITEL,STO, COUNT(rk) as node from tb_hw group by trx,JENIS_PROJECT,WITEL,STO
union all
SELECT trx,JENIS_PROJECT,WITEL,STO, COUNT(rk) as node from tb_ZTE group by trx,JENIS_PROJECT,WITEL,STO
union all
SELECT trx,JENIS_PROJECT,WITEL,STO, COUNT(rk) as node from tb_fh group by trx,JENIS_PROJECT,WITEL,STO