case when success then 'succeeded' else 'failed' end as success,

min(gas_used) as min_gas_used,

max(gas_used) as max_gas_used

from ethereum.transactions

where --tx_id in (select tx_id from claims)

function_signature = '0x76122903'

and to_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'

group by 1

limit 100