# in package DB::Contribition

__PACKAGE__->set_sql(average_dollars => <<'END_SQL' );
SELECT AVG(amount)
FROM   contribution
END_SQL

sub average_dollars {
    my $class = shift;
    my $sth  = $class->sql_average_dollars();
    $sth->execute();
    return $sth->select_val() || 0;
}