SELECT

'Ethereum' AS chain,

origin_from_address AS minter,

ROUND(SUM(decoded_log:value / 1e8)) AS total_minted

FROM ethereum.core.ez_decoded_event_logs

WHERE

contract_address = LOWER('0x8236a87084f8B84306f72007F36F2618A5634494')

AND decoded_log:from = '0x0000000000000000000000000000000000000000'

AND event_name = 'Transfer'

GROUP BY 1, 2

UNION ALL

SELECT

'Base' AS chain,

origin_from_address AS minter,

ROUND(SUM(decoded_log:value / 1e8)) AS total_minted

FROM base.core.ez_decoded_event_logs

WHERE

contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')

AND decoded_log:from = '0x0000000000000000000000000000000000000000'

AND event_name = 'Transfer'

GROUP BY 1, 2

UNION ALL

SELECT

'BSC' AS chain,

origin_from_address AS minter,

ROUND(SUM(decoded_log:value / 1e8)) AS total_minted

FROM bsc.core.ez_decoded_event_logs

WHERE

contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')

AND decoded_log:from = '0x0000000000000000000000000000000000000000'

AND event_name = 'Transfer'