count_if(status = 'SUCCESS') as SUCCESS,

(SUCCESS/count(TX_HASH))*100 as SUCCESS_RATE

from gnosis.core.fact_transactions where block_timestamp::date>='2022-06-01' and block_timestamp::date<='2022-07-31'

group by 1