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
Preview:
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