SELECT nimmhs, sum(Matakuliah.sks)
FROM (SELECT Mahasiswa.nim AS nimmhs, Kuliah.kodemk AS b, max(thnakademik) FROM Mahasiswa, Peserta, Kuliah
      WHERE Mahasiswa.nim = Peserta.nim AND Peserta.kodekuliah = Kuliah.kodekuliah
      GROUP BY Mahasiswa.nim, Kuliah.kodemk) AS table1, Matakuliah
WHERE b = Matakuliah.kodemk GROUP BY nimmhs