oracle 비율구하기 쿼리

WITH T AS (

  SELECT 'id1' AS id, 'abc' AS t, 2 AS cnt FROM DUAL UNION ALL

  SELECT 'id1', 'bbb', 1 FROM DUAL UNION ALL

  SELECT 'id1', 'ccc', 1 FROM DUAL UNION ALL

  SELECT 'id2', 'aaa', 1 FROM DUAL UNION ALL

  SELECT 'id2', 'abc', 1 FROM DUAL

)

SELECT

  T.*,

  RATIO_TO_REPORT(cnt) OVER(PARTITION BY id)

FROM

  T