with totalsupplytbl as (

with general as (

with tbl3 as (

with tbl as (

select

to_address as "Address",

sum(amount) as "Input"

from base.core.ez_token_transfers

where contract_address = lower ('0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4')

group by

1

),

tbl2 as (

select

from_address as "Address",

sum(amount) as "Output"

from base.core.ez_token_transfers

where contract_address = lower ('0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4')

group by 1

)

select

tbl."Address",

case

when "Input" is null then 0

else "Input"

end as "Input tokens",

case

when "Output" is null then 0

else "Output"

end as "Output tokens"

from tbl left join tbl2 on tbl."Address" = tbl2."Address"

)

select

"Address",

"Input tokens",