Help for this page

Select Code to Download

Select or download this

SELECT 
  users.name, AVG(tests.score)
...
  users.name=tests.name
GROUP BY users.name
ORDER BY users.name;