select a.date, e.name, a.format, c.name as subject_name, d.name as student_name, a.max_points, b.points from group_tests a join student_results b on a.test_id = b.test_id join subjects c on a.subject_id = c.id join students d on b.student_id = d.student_id join groups e on a.group_id = e.group_id where e.group_id = 29