Miscellany

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, MatakuliahWHERE b = Matakuliah.kodemk GROUP BY nimmhs