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