tx_fee,

(SELECT MAX(gas_used) FROM arbitrum.core.fact_transactions WHERE status = 'FAIL') as max_gas_used_on_failed_tx,

(SELECT MAX(gas_used) FROM arbitrum.core.fact_transactions WHERE status = 'SUCCESS') as max_gas_used_on_success_tx

FROM

arbitrum.core.fact_transactions

LIMIT 10;