Query editor
WITH zkp_requests AS (SELECT COUNT(*) AS total_requestsFROM zksync.transactionsWHERE block_time >= NOW() - INTERVAL '30' DAY),zkp_success AS (SELECT COUNT(*) AS success_verifiesFROM zksync.transactionsWHERE block_time >= NOW() - INTERVAL '30' DAYAND gas_used > 0 -- 가스가 사용되었다면 성공으로 간주)SELECTROUND(success_verifies * 100.0 / NULLIF(total_requests, 0), 2) AS success_rate_pct,total_requests,success_verifies,total_requests - success_verifies AS failed_requests,CASEWHEN success_verifies * 100.0 / NULLIF(total_requests, 0) >= 95 THEN 'Excellent'WHEN success_verifies * 100.0 / NULLIF(total_requests, 0) >= 90 THEN 'Good'WHEN success_verifies * 100.0 / NULLIF(total_requests, 0) >= 80 THEN 'Fair'ELSE 'Poor'END AS statusFROM zkp_requests, zkp_success;