program_name,

AVG(CASE WHEN succeeded THEN 1 ELSE 0 END) AS success_rate

FROM

solana.gov.fact_gauges_votes

GROUP BY

program_name;