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