版本與可重現性

— 無確信比例 —

-- 無第三方確信比例（口徑：TWSE+TPEx）
SELECT
  COUNT(CASE WHEN has_assurance = false THEN 1 END) AS no_assurance_count,
  COUNT(*) AS total_listed,
  ROUND(
    100.0 * COUNT(CASE WHEN has_assurance = false THEN 1 END) / COUNT(*),
    1
  ) AS no_assurance_pct
FROM company_scores
WHERE market_type IN ('0', '1')  -- 上市=0, 上櫃=1，不含興櫃
  AND scoring_run_id = :latest_run_id;
-- Expected: ~58% as of 2026-03-01

— 確信機構同集團比例 —

-- 確信機構與簽證同集團比例（分母：有確信公司）
SELECT
  COUNT(CASE WHEN gf014_triggered = true THEN 1 END) AS gf014_count,
  COUNT(*) AS has_assurance_count,
  ROUND(
    100.0 * COUNT(CASE WHEN gf014_triggered = true THEN 1 END) / COUNT(*),
    1
  ) AS gf014_pct
FROM company_scores
WHERE market_type IN ('0', '1')
  AND has_assurance = true      -- 分母限定有確信公司
  AND scoring_run_id = :latest_run_id;

— 總掃描公司數 —

-- 總掃描公司數（口徑：TWSE+TPEx）
SELECT COUNT(*) AS universe_size
FROM companies
WHERE market_type IN ('0', '1')
  AND entity_type NOT IN ('TDR', 'ETF');
-- Expected: 0 as of 2026-03-01