Preview:
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
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter