sum(DECODED_LOG:value/pow(10,18)) as "Volume in $ETH", count(DISTINCT tx_hash) as "Total Upgrades",

count(DISTINCT ORIGIN_FROM_ADDRESS ) as user

from blast.core.ez_decoded_event_logs

where --tx_hash = '0xe164e281474b5485a1214b362d5b6afa7b37d4792396af6d86412e780b4ccbed' and

EVENT_NAME = 'Upgrade'

and CONTRACT_ADDRESS = '0x9ad0e3ad90cae1e6acb1cc39cd82867f391b2478'

and ORIGIN_TO_ADDRESS = '0x9ad0e3ad90cae1e6acb1cc39cd82867f391b2478'

GROUP by all