Prueba de esta manera
Código PHP:
$sql=mysql_query("select country, count(provider_id)as total from provider group by country order by total DESC Limit 5 ");
$total=0;
while($row=mysql_fetch_array($sql)){
$total+= $row["total"];
}
echo "total = ".$total;
Saludos!
