instruction:accounts[0] as wallets

FROM solana.core.fact_events

WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'

AND instruction:accounts[1] = '{{Player_Profile}}'

--AND instruction:accounts[1] = ''

AND instruction:accounts[4] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'

AND succeeded = 'true'

AND block_timestamp > '2024-04-04' AND block_timestamp < current_date

group by 1

,mining AS (

select

date_trunc('day', block_timestamp::date) as date

----------------------------------------------------

,zeroifnull(sum(case when value:parsed:info:authority = 'qe84yNaK76yaZqGqyWJ9A1Npgnt4NSzicbcZvxEQuJy'

then value:parsed:info:amount

end)) as ARCO_mined

,zeroifnull(sum(case when value:parsed:info:authority = 'CHxH1BkLp5A6VcQFCYqKGW88i5XFJV5KyyxewSiwcbkB'

then value:parsed:info:amount

end)) as BIOMASS_mined

,zeroifnull(sum(case when value:parsed:info:authority = '6ny545QXZbGDWXo6F7UEVC7MncAzNNxB62tbVoYWG5gs'

then value:parsed:info:amount

end)) as CARBON_mined

,zeroifnull(sum(case when value:parsed:info:authority = '4rZNPtbe9kD44RNdf5XxB6RBWsWaHTg76esbrkWGpkXU'

then value:parsed:info:amount

end)) as CUORE_mined

,zeroifnull(sum(case when value:parsed:info:authority = '9LPyad7NE1VDApsirv46gMrRhbmsbFGMMy5CUiAQXkfP'