my $sth = $dbh->prepare("SELECT avg(...) FROM prospects");
$sth->execute;
my ($avg) = $sth->fetchrow_array;

##</code><code>##

my ($avg) = $dbh->selectrow_array("SELECT avg(...) FROM prospects");