signers[0] as wallet,

zeroifnull(sum(case when instruction:accounts[4] = 'MUD6bCtMW8sAkMWcBD14bpG65KaJ9Li1mpxmtWhWSWM'

then value:parsed:info:amount / POW(10,8) end)) AS MUD_ATLAS_claimed,

zeroifnull(sum(case when instruction:accounts[4] = 'oniXZY2D8nDXnmt8vSgqWoytdcegWaN7rhfoUWU2QxT'

then value:parsed:info:amount / POW(10,8) end)) AS ONI_ATLAS_claimed,

zeroifnull(sum(case when instruction:accounts[4] = 'ustur3pr1QKYbaCJ3pQsCPUhQLRfLXZbsx4YWaJbt8r'

then value:parsed:info:amount / POW(10,8) end)) AS USTUR_ATLAS_claimed,

MUD_ATLAS_claimed + ONI_ATLAS_claimed+ USTUR_ATLAS_claimed as ATLAS_claimed,

case when MUD_ATLAS_claimed > ONI_ATLAS_claimed AND MUD_ATLAS_claimed > USTUR_ATLAS_claimed

then 'MUD'

when ONI_ATLAS_claimed > MUD_ATLAS_claimed AND ONI_ATLAS_claimed > USTUR_ATLAS_claimed

then 'ONI'

when USTUR_ATLAS_claimed > ONI_ATLAS_claimed AND USTUR_ATLAS_claimed > MUD_ATLAS_claimed

then 'USTUR' end as faction

from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)

WHERE program_id = 'PsToRxhEPScGt1Bxpm7zNDRzaMk31t8Aox7fyewoVse'

AND succeeded = 'true'

AND instruction:accounts[4] IN ('MUD6bCtMW8sAkMWcBD14bpG65KaJ9Li1mpxmtWhWSWM', 'oniXZY2D8nDXnmt8vSgqWoytdcegWaN7rhfoUWU2QxT', 'ustur3pr1QKYbaCJ3pQsCPUhQLRfLXZbsx4YWaJbt8r')

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

group by 1