select count(*) as num_of_txns,
case
when status = 'SUCCESS' then 'Successful Txns'
when status = 'FAIL' then 'Failed Txns'
else null
end as Status
from arbitrum.core.fact_transactions
where block_timestamp >= CURRENT_TIMESTAMP - interval '24 hours'
group by 2