SELECT q.name, s.name, ts.score
FROM tquizzes q
JOIN tquizscores ts
ON q.id = ts.tquiz
JOIN students s
ON ts.student = s.id
ORDER BY s.name, q.id
