select tbbebantugas.*, tbperkuliahan.kelas from tbbebantugas inner join tbperkuliahan on tbbebantugas.nama = tbperkuliahan.dosen where tbperkuliahan.sm = 'GENAP' and tbperkuliahan.tahun = '2016/2017' group by tbbebantugas.nama order by id desc