proposer,

count(*) as tx_failure

FROM flow.core.fact_transactions

WHERE tx_succeeded = TRUE

AND not (proposer is NULL)

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10