這是我的查詢
SELECT SUM(nilai.nilai) as total, COUNT(nilai.nilai) as baris FROM nilai JOIN data_nilai
ON nilai.id_data_nilai = data_nilai.idx
WHERE data_nilai.id_tahun_ajar = '1'
AND data_nilai.id_sekolah = '1040902040'
AND data_nilai.id_kelas = '2'
AND data_nilai.id_rombel = '2'
AND data_nilai.id_mapel = '13'
AND data_nilai.status_nilai = '0'
AND data_nilai.id_jn = '1'
AND nilai.user_id = 'IDS0000707'
UNION
SELECT SUM(nilai.nilai) as total, COUNT(nilai.nilai) as baris FROM nilai JOIN data_nilai
ON nilai.id_data_nilai = data_nilai.idx
WHERE data_nilai.id_tahun_ajar = '1'
AND data_nilai.id_sekolah = '1040902040'
AND data_nilai.id_kelas = '2'
AND data_nilai.id_rombel = '2'
AND data_nilai.id_mapel = '13'
AND data_nilai.status_nilai = '0'
AND data_nilai.id_jn = '2'
AND nilai.user_id = 'IDS0000707'
UNION
SELECT SUM(nilai.nilai) as total, COUNT(nilai.nilai) as baris FROM nilai JOIN data_nilai
ON nilai.id_data_nilai = data_nilai.idx
WHERE data_nilai.id_tahun_ajar = '1'
AND data_nilai.id_sekolah = '1040902040'
AND data_nilai.id_kelas = '2'
AND data_nilai.id_rombel = '2'
AND data_nilai.id_mapel = '13'
AND data_nilai.status_nilai = '0'
AND data_nilai.id_jn = '3'
AND nilai.user_id = 'IDS0000707'
UNION
SELECT SUM(nilai.nilai) as total, COUNT(nilai.nilai) as baris FROM nilai JOIN data_nilai
ON nilai.id_data_nilai = data_nilai.idx
WHERE data_nilai.id_tahun_ajar = '1'
AND data_nilai.id_sekolah = '1040902040'
AND data_nilai.id_kelas = '2'
AND data_nilai.id_rombel = '2'
AND data_nilai.id_mapel = '13'
AND data_nilai.status_nilai = '0'
AND data_nilai.id_jn = '8'
AND nilai.user_id = 'IDS0000707'