01_platform_benchmark.sql

-- Platform Enforcement Reliability Audit
-- Platform benchmark: scale, automation, appeals and intensity.

SELECT
    platform,
    enforcement_volume,
    ROUND(
        100.0 * automated_detection_volume / NULLIF(enforcement_volume, 0),
        2
    ) AS automation_exposure_pct,
    complaints_received,
    decisions_reversed,
    ROUND(
        100.0 * decisions_reversed / NULLIF(appeals_resolved, 0),
        2
    ) AS reversal_rate_resolved_pct,
    ROUND(
        1000000.0 * enforcement_volume / NULLIF(active_users, 0),
        0
    ) AS measures_per_million_users,
    ROUND(
        1000000.0 * complaints_received / NULLIF(active_users, 0),
        0
    ) AS complaints_per_million_users,
    ROUND(
        100.0 * severe_restrictions_reported / NULLIF(enforcement_volume, 0),
        2
    ) AS severe_restrictions_per_100_measures
FROM platform_summary
ORDER BY enforcement_volume DESC;