select riderid, AVG(score) 
  from eventscores
 group by riderid
 order by riderid