SQL每日一题(20210104)求出NAME中每组累加/每组总数的比例大于0.6的ID和NAME

SQL每日一题(20210610)
SQL每日一题(20210907)
SQL每日一题(20220223)
SQL每日一题(20220627)

SELECT B.ID, B.NAME, B.NUM  FROM
(
   SELECT A.*,
   SUM(A.NUM) OVER(PARTITION BY A.NAME ORDER BY A.ID) /
   SUM(A.NUM) OVER(PARTITION BY A.NAME) AS Ratio
   FROM T0104 A
)B WHERE B.Ratio >= 0.6;

SELECT X.ID, X.NAME, X.NUM
FROM (SELECT T.*,
             (SELECT SUM(T1.NUM)
              FROM T0104 T1
              WHERE T1.ID <= T.ID
                AND T1.NAME = T.NAME) / (SELECT SUM(T2.NUM) FROM T0104 T2 WHERE T2.NAME = T.NAME) 比率
      FROM T0104 T) X
WHERE X.比率 >0.6;