get old results

PHOTO EMBED

Fri Feb 18 2022 05:18:43 GMT+0000 (Coordinated Universal Time)

Saved by @vvnezapnopwnz #json

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
content_copyCOPY