SQL get calculation

SELECT d.nipd, d.nama,
       SUM(dr.bio) AS bio_total,
       SUM(dr.fis) AS fis_total,
       SUM(dr.kim) AS kim_total,
       SUM(dr.mtkp) AS mtkp_total,
       (SUM(dr.agm) + SUM(dr.pp) + SUM(dr.bin) + SUM(dr.mtk) + SUM(dr.sej) + SUM(dr.bing) + SUM(dr.sen) + SUM(dr.pjok) + SUM(dr.pkwu) + SUM(dr.bio) + SUM(dr.fis) + SUM(dr.kim) + SUM(dr.mtkp) + SUM(dr.ekolm) + SUM(dr.bjer)) AS total
FROM dapodik_rapor dr
JOIN dapodik d ON dr.nipd = d.nipd
GROUP BY d.nipd, d.nama
ORDER BY total desc


-- IPS ada di bawah ---------
SELECT d.nipd, d.nama,
       SUM(dr.mtk) AS mtk_total,
       SUM(dr.bin) AS bin_total,
       SUM(dr.sos) AS sos_total,
       (SUM(dr.agm) + SUM(dr.pp) + SUM(dr.bin) + SUM(dr.mtk) + SUM(dr.sej) + SUM(dr.bing) + SUM(dr.sen) + SUM(dr.pjok) + SUM(dr.pkwu) + SUM(dr.bjep) + SUM(dr.sejp) + SUM(dr.geo) + SUM(dr.sos) + SUM(dr.eko) + SUM(dr.bjer)) AS total
FROM dapodik_rapor dr
JOIN dapodik d ON dr.nipd = d.nipd
GROUP BY d.nipd, d.nama
HAVING sos_total IS NOT NULL
ORDER BY total DESC