Perintah mengumpulkan data aktifitas mengajar guru 1 minggu

 SELECT 
    u.lastname AS nama_guru,
    c.name AS kelas,
    j.matapelajaran,
    j.jamke
FROM mdl_local_jurnalmengajar j
JOIN mdl_user u ON u.id = j.userid
JOIN mdl_cohort c ON c.id = j.kelas
WHERE j.timecreated BETWEEN 
      UNIX_TIMESTAMP('2025-08-25 00:00:00') 
  AND UNIX_TIMESTAMP('2025-08-29 23:59:59')
ORDER BY u.lastname ASC;