Pasted

SELECT 
    A.nama_alternatif,
    IFNULL(SUM(CASE WHEN K.nama_kriteria = 'penyelesaian akhir' THEN R.nilai_rangking END),0) AS 'penyelesaian akhir',
    IFNULL(SUM(CASE WHEN K.nama_kriteria = 'shooting' THEN R.nilai_rangking END),0) AS 'shooting',
    IFNULL(SUM(CASE WHEN K.nama_kriteria = 'passing' THEN R.nilai_rangking END),0) AS 'passing',
    IFNULL(SUM(CASE WHEN K.nama_kriteria = 'heading' THEN R.nilai_rangking END),0) AS 'heading',
    IFNULL(SUM(CASE WHEN K.nama_kriteria = 'kerja sama tim' THEN R.nilai_rangking END),0) AS 'kerja sama tim',
    IFNULL(SUM(CASE WHEN K.nama_kriteria = 'kecepatan' THEN R.nilai_rangking END),0) AS 'kecepatan',
    IFNULL(SUM(CASE WHEN K.nama_kriteria = 'stamina' THEN R.nilai_rangking END),0) AS 'stamina'
FROM `rangking` R
    LEFT JOIN `alternatif` A ON A.id_alternatif = R.id_alternatif
    LEFT JOIN `kriteria` K ON K.id_kriteria = R.id_kriteria
    GROUP BY A.nama_alternatif ORDER BY A.nama_alternatif DESC