Help for this page

Select Code to Download


  1. or download this
    $eventscores = [
     [riderid, actionid, score],
    ...
     [riderid, actionid, score],
     ...
    ];
    
  2. or download this
    $eventscores = {
      riderid => {
    ...
      },
      ...
    };
    
  3. or download this
    foreach my $rider (keys %$eventscores) {
     my @scores = values %{$eventscores->{$rider}};
    ...
    
     # do something with $rider and @scores
    }
    
  4. or download this
    select riderid, AVG(score) 
      from eventscores
     group by riderid
     order by riderid