USNI - Ambil Rata-rata Quesioner

select
  concat(a.TAHUN-1,a.semester) PERIODE,
  b.IDDOSEN,
  b.IDMAKUL,
  d.NAMA NAMA_MATAKULIAH,
  concat(e.GELARDEPAN,' ',e.NAMA,' ',e.GELARAKADEMIK) NAMA_DOSEN,
  AVG(c.POIN)
from
  kuesionerpp_soal a
  join kuesionerpp_hasil b on a.ID = b.IDKUESIONER
  join kuesionerpp_jawabanpg c on a.TAHUN = c.TAHUN and a.SEMESTER = c.SEMESTER and b.JAWABAN = c.id
  join makul d on b.IDMAKUL = d.ID
  join dosen e on b.IDDOSEN = e.ID
where
  a.TAHUN = '2025'
  and a.semester = '1'
  and a.JENISJAWABAN = '1'
group by
	b.IDDOSEN,
	b.IDMAKUL;

select
  a.PERTANYAAN,
  ';',
  AVG(c.POIN)
from
  kuesionerpp_soal a
  join kuesionerpp_hasil b on a.ID = b.IDKUESIONER
  join kuesionerpp_jawabanpg c on a.TAHUN = c.TAHUN and a.SEMESTER = c.SEMESTER and b.JAWABAN = c.id
  join makul d on b.IDMAKUL = d.ID
  join dosen e on b.IDDOSEN = e.ID
where
  a.TAHUN = '2025'
  and a.semester = '1'
  and a.JENISJAWABAN = '1'
group by
	a.PERTANYAAN;

select
  concat(a.TAHUN-1,a.semester) PERIODE,
  b.IDDOSEN,
  concat(e.GELARDEPAN,' ',e.NAMA,' ',e.GELARAKADEMIK) NAMA_DOSEN,
    b.IDMAKUL,
      d.NAMA NAMA_MATAKULIAH,
      f.NAMA IDKELAS,
  a.PERTANYAAN,
  ';',
  AVG(c.POIN)
from
  kuesionerpp_soal a
  join kuesionerpp_hasil b on a.ID = b.IDKUESIONER
  join kuesionerpp_jawabanpg c on a.TAHUN = c.TAHUN and a.SEMESTER = c.SEMESTER and b.JAWABAN = c.id
  join makul d on b.IDMAKUL = d.ID
  join dosen e on b.IDDOSEN = e.ID
  join labelkelas f on b.KELAS = f.ID
where
  a.TAHUN = '2025'
  and a.semester = '1'
  and a.JENISJAWABAN = '1'
group by
	b.IDDOSEN,
	b.IDMAKUL,
	b.KELAS,
	a.PERTANYAAN;