SELECT 
    source_table,
    total_anis,
    total_prabowo,
    total_ganjar,
    (total_anis / (total_anis + total_prabowo + total_ganjar)) * 100 AS total_percentage_anis,
    (total_prabowo / (total_anis + total_prabowo + total_ganjar)) * 100 AS total_percentage_prabowo,
    (total_ganjar / (total_anis + total_prabowo + total_ganjar)) * 100 AS total_percentage_ganjar
FROM (
    SELECT 
        'datatpsaceh' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsaceh
    
	UNION ALL
    SELECT 
        'datatpsbali' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsbali
    
	UNION ALL
    SELECT 
        'datatpsbangka' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsbangka
    
	UNION ALL
    SELECT 
        'datatpsbanten' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsbanten
    
	UNION ALL
    SELECT 
        'datatpsbengkulu' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsbengkulu
    
	UNION ALL
    SELECT 
        'datatpsgorontalo' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsgorontalo
    
	UNION ALL
    SELECT 
        'datatpsjabar' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsjabar
    
	UNION ALL
    SELECT 
        'datatpsjakarta' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsjakarta
    
	UNION ALL
    SELECT 
        'datatpsjambi' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsjambi
    
	UNION ALL
    SELECT 
        'datatpsjateng' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsjateng
    
	UNION ALL
	SELECT 
        'datatpsjatim' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsjatim
    
	UNION ALL
	SELECT 
        'datatpsjogja' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsjogja
    
	UNION ALL
	SELECT 
        'datatpskalbar' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpskalbar
    
	UNION ALL
	SELECT 
        'datatpskalsel' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpskalsel
    
	UNION ALL
	SELECT 
        'datatpskalteng' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpskalteng
    
	UNION ALL
	SELECT 
        'datatpskaltim' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpskaltim
    
	UNION ALL
	SELECT 
        'datatpskalut' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpskalut
    
	UNION ALL
	SELECT 
        'datatpslampung' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpslampung
    
	UNION ALL
	SELECT 
        'datatpsluarnegeri' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsluarnegeri
    
	UNION ALL
	SELECT 
        'datatpsmaluku' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsmaluku
    
	UNION ALL
	SELECT 
        'datatpsmalukuutara' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsmalukuutara
    
	UNION ALL
	SELECT 
        'datatpsntb' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsntb
    
	UNION ALL
	SELECT 
        'datatpsntt' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsntt
    
	UNION ALL
	SELECT 
        'datatpspapua' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpspapua
    
	UNION ALL
	SELECT 
        'datatpspapuabarat' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpspapuabarat
    
	UNION ALL
	SELECT 
        'datatpspapuabaratdaya' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpspapuabaratdaya
    
	UNION ALL
	SELECT 
        'datatpspapuapegunungan' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpspapuapegunungan
    
	UNION ALL
	SELECT 
        'datatpspapuaselatan' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpspapuaselatan
    
	UNION ALL
	SELECT 
        'datatpspapuatengah' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpspapuatengah
    
	UNION ALL
	SELECT 
        'datatpsriau' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsriau
    
	UNION ALL
	SELECT 
        'datatpsriaukepulauan' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpsriaukepulauan
    
	UNION ALL
	SELECT 
        'datatpssulbar' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpssulbar
    
	UNION ALL
	SELECT 
        'datatpssulsel' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpssulsel
    
	UNION ALL
	SELECT 
        'datatpssultengah' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpssultengah
    
	UNION ALL
	SELECT 
        'datatpssultenggara' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpssultenggara
    
	UNION ALL
	SELECT 
        'datatpssulutara' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpssulutara
    
	UNION ALL
	SELECT 
        'datatpssumaterabarat' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpssumaterabarat
    
	UNION ALL
	SELECT 
        'datatpssumateraselatan' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpssumateraselatan
    
	UNION ALL
	SELECT 
        'datatpssumaterautara' AS source_table, 
        SUM(anis) AS total_anis, 
        SUM(prabowo) AS total_prabowo, 
        SUM(ganjar) AS total_ganjar
    FROM datatpssumaterautara
    
	UNION ALL
    SELECT 
        'Total' AS source_table,
        SUM(anis) AS total_anis,
        SUM(prabowo) AS total_prabowo,
        SUM(ganjar) AS total_ganjar
    FROM (
        SELECT * FROM datatpsaceh
        UNION ALL
        SELECT * FROM datatpsbali
		UNION ALL
        SELECT * FROM datatpsbangka
		UNION ALL
        SELECT * FROM datatpsbanten
		UNION ALL
        SELECT * FROM datatpsbengkulu
		UNION ALL
        SELECT * FROM datatpsgorontalo
		UNION ALL
        SELECT * FROM datatpsjabar
		UNION ALL
        SELECT * FROM datatpsjakarta
		UNION ALL
        SELECT * FROM datatpsjambi
		UNION ALL
        SELECT * FROM datatpsjateng
		UNION ALL
        SELECT * FROM datatpsjatim
		UNION ALL
        SELECT * FROM datatpsjogja
		UNION ALL
        SELECT * FROM datatpskalbar
		UNION ALL
        SELECT * FROM datatpskalsel
		UNION ALL
        SELECT * FROM datatpskalteng
		UNION ALL
        SELECT * FROM datatpskaltim
		UNION ALL
        SELECT * FROM datatpskalut
		UNION ALL
        SELECT * FROM datatpslampung
		UNION ALL
        SELECT * FROM datatpsluarnegeri
		UNION ALL
        SELECT * FROM datatpsmaluku
		UNION ALL
        SELECT * FROM datatpsmalukuutara
		UNION ALL
        SELECT * FROM datatpsntb
		UNION ALL
        SELECT * FROM datatpsntt
		UNION ALL
        SELECT * FROM datatpspapua
		UNION ALL
        SELECT * FROM datatpspapuabarat
		UNION ALL
        SELECT * FROM datatpspapuabaratdaya
		UNION ALL
        SELECT * FROM datatpspapuapegunungan
		UNION ALL
        SELECT * FROM datatpspapuaselatan
		UNION ALL
        SELECT * FROM datatpspapuatengah
		UNION ALL
        SELECT * FROM datatpsriau
		UNION ALL
        SELECT * FROM datatpsriaukepulauan
		UNION ALL
        SELECT * FROM datatpssulbar
		UNION ALL
        SELECT * FROM datatpssulsel
		UNION ALL
        SELECT * FROM datatpssultengah
		UNION ALL
        SELECT * FROM datatpssultenggara
		UNION ALL
        SELECT * FROM datatpssulutara
		UNION ALL
        SELECT * FROM datatpssumaterabarat
		UNION ALL
        SELECT * FROM datatpssumateraselatan
		UNION ALL
        SELECT * FROM datatpssumaterautara
		
		
    ) AS combined_data
) AS combined_data
GROUP BY source_table;