SELECT
    (SELECT SUM(anis) FROM datatpsbengkulu) AS total_anis,
    (SELECT SUM(prabowo) FROM datatpsbengkulu) AS total_prabowo,
    (SELECT SUM(ganjar) FROM datatpsbengkulu) AS total_ganjar,
    (SELECT SUM(anis) + SUM(prabowo) + SUM(ganjar) FROM datatpsbengkulu) AS total_suara_kotor,
    anis_databermasalah,
    prabowo_databermasalah,
    ganjar_databermasalah,
    (anis_databermasalah + prabowo_databermasalah + ganjar_databermasalah) AS suara_bermasalah,
    (SELECT SUM(anis) FROM datatpsbengkulu) - anis_databermasalah AS anis_bersih,
    (SELECT SUM(prabowo) FROM datatpsbengkulu) - prabowo_databermasalah AS prabowo_bersih,
    (SELECT SUM(ganjar) FROM datatpsbengkulu) - ganjar_databermasalah AS ganjar_bersih,
	
	 ((SELECT SUM(anis) FROM datatpsbengkulu) - anis_databermasalah) * 100 / ((SELECT SUM(anis) FROM datatpsbengkulu) - anis_databermasalah + (SELECT SUM(prabowo) FROM datatpsbengkulu) - prabowo_databermasalah + (SELECT SUM(ganjar) FROM datatpsbengkulu) - ganjar_databermasalah) AS anis_bersih_percentage,
	 
	 ((SELECT SUM(prabowo) FROM datatpsbengkulu) - prabowo_databermasalah) * 100 / ((SELECT SUM(anis) FROM datatpsbengkulu) - anis_databermasalah + (SELECT SUM(prabowo) FROM datatpsbengkulu) - prabowo_databermasalah + (SELECT SUM(ganjar) FROM datatpsbengkulu) - ganjar_databermasalah) AS prabowo_bersih_percentage,
	 
	 ((SELECT SUM(ganjar) FROM datatpsbengkulu) - ganjar_databermasalah) * 100 / ((SELECT SUM(anis) FROM datatpsbengkulu) - anis_databermasalah + (SELECT SUM(prabowo) FROM datatpsbengkulu) - prabowo_databermasalah + (SELECT SUM(ganjar) FROM datatpsbengkulu) - ganjar_databermasalah) AS ganjar_bersih_percentage,
	 
    (SELECT COUNT(*) FROM datatpsbengkulu WHERE suara_total > pengguna_total_j) AS tps_bermasalah,
    (SELECT COUNT(*) FROM datatpsbengkulu WHERE pengguna_total_j = 0) AS dpt_masih_nol
FROM (
    SELECT 
        SUM(anis) AS anis_databermasalah,
        SUM(prabowo) AS prabowo_databermasalah,
        SUM(ganjar) AS ganjar_databermasalah,
        SUM(suara_total) AS suara_total_bermasalah,
        SUM(pengguna_total_j) AS semua_pengguna_total_j
    FROM 
        datatpsbengkulu 
    WHERE 
        suara_total > pengguna_total_j
) AS subquery_alias;