SELECT group_name,teacher,datetime 
FROM (
  SELECT datetime,groups.name AS group_name,users.name AS teacher 
  FROM study_process,students,groups,users
  WHERE groups.id = students.group
  AND students.id = study_process.student_id
  AND users.id = groups.owner
  ORDER BY groups.name,datetime DESC
) AS tmp
GROUP BY group_name