count (distinct tx_id) / (Select Count(distinct tx_id) From cosmos.core.fact_msgs Where tx_succeeded = true) * 100 as "Percentage"

from cosmos.core.fact_msgs

Where tx_succeeded = true

group by 1 order by 2 desc

limit 20