我认为使用数组、循环和聚合可以帮助您实现这一点。比如说你声明/初始化你的数组像这样...

$exams = array('chem1_1', 'chem1_2', 'chem2_1', 'chem2_2', 'chem3_1', 'chem3_2', 'chem4_1', 'chem4_2');
$categories = array('M', 'F', 'Total');
$totals = array_fill_keys($categories, 0);
$counts = array_fill_keys($categories, 0);

字符串
然后你可以这样循环

$whereCondition = "(cls='$cls_show' AND section='$sect_show') AND (";
foreach ($exams as $index => $exam) {
    if ($index !== 0) {
        $whereCondition .= " OR ";
    }
    $whereCondition .= "($exam > 50 AND $exam < 81)";
}
$whereCondition .= ")";

$query = "SELECT sex, COUNT(*) AS count, AVG((chem1_1 + chem1_2 + chem2_1 + chem2_2 + chem3_1 + chem3_2 + chem4_1 + chem4_2) / 8) AS average,
          (SUM(chem1_1 > 50 AND chem1_1 < 81) + SUM(chem1_2 > 50 AND chem1_2 < 81) + SUM(chem2_1 > 50 AND chem2_1 < 81) + SUM(chem2_2 > 50 AND chem2_2 < 81) +
           SUM(chem3_1 > 50 AND chem3_1 < 81) + SUM(chem3_2 > 50 AND chem3_2 < 81) + SUM(chem4_1 > 50 AND chem4_1 < 81) + SUM(chem4_2 > 50 AND chem4_2 < 81)) AS pass_count
          FROM test_2324 WHERE $whereCondition GROUP BY sex";
$result = mysqli_query($db, $query);

while ($row = mysqli_fetch_assoc($result)) {
    $category = $row['sex'];
    $count = $row['count'];
    $passCount = $row['pass_count'];

    $totals[$category] += $passCount;
    $counts[$category] += $count;
}

$passPercentage = array();
$average = array();
foreach ($categories as $category) {
    $passPercentage[$category] = ($totals[$category] / ($counts[$category] * count($exams))) * 100;
    $average[$category] = $totals[$category] / $counts[$category];
}

型
然后，您可以根据需要在同一页面上回显这些值。