如何在SQL中找到百分比?

您需要一个子查询来运行计算

SELECT
    Survived,
    cnt,
    (cnt * 100.0 / (SELECT SUM(cnt) FROM survival_data)) AS "%"
FROM
    survival_data;

您可以使用窗口函数,这将比子查询更有效。您还需要转换或乘以小数。

SELECT
    Survived,
    cnt,
    cnt * 100.0 / SUM(cnt) OVER () AS "%"
FROM
    survival_data;