$sql = "
SELECT SUM(risk_score) AS total_risk
FROM SNPs
WHERE phenotype LIKE '%Breast Cancer%'
";

$result = $conn->query($sql);

$row = $result->fetch_assoc();

$total_risk = (float)$row['total_risk'];

echo $total_risk;