with fish_whale as (select sum(round(array_size(INNER_INSTRUCTION:instructions)/4)) as number , instruction:accounts[0] as users from solana.fact_events where (inner_instruction:instructions[0]:parsed:type='createAccount' or inner_instruction:instructions[0]:parsed:type='createAccount') and (inner_instruction:instructions[1]:parsed:type='initializeAccount' or inner_instruction:instructions[1]:parsed:type='createAccount') and (inner_instruction:instructions[2]:parsed:type='transfer' or inner_instruction:instructions[2]:parsed:type='initializeAccount' ) and (inner_instruction:instructions[3]:parsed:type='transfer' or inner_instruction:instructions[3]:parsed:type is null) and program_id='EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J' group by users) select count(1) as datas,'a.Users staked less than 5 NFTs' as label from fish_whale where number <5 UNION select count(1) as datas,'b.Users staked between 5 to 10 NFTs' as label from fish_whale where number >= 5 and number < 10 UNION select count(1) as datas,'c.Users staked between 10 to 20 NFTs' as label from fish_whale where number >= 10 and number < 20 UNION select count(1) as datas,'d.Users staked between 20 to 30 NFTs' as label from fish_whale where number >= 20 and number < 30 UNION select count(1) as datas,'e.Users staked between 30 to 40 NFTs' as label from fish_whale where number >= 30 and number < 40 UNION select count(1) as datas,'f.Users staked between 40 to 50 NFTs' as label from fish_whale where number >= 40 and number < 50 UNION select count(1) as datas,'g.Users staked between 50 to 60 NFTs' as label from fish_whale where number >= 50 and number < 60 UNION select count(1) as datas,'h.Users staked between 60 to 70 NFTs' as label from fish_whale where number >= 60 and number < 70 UNION select count(1) as datas,'i.Users staked between 70 to 80 NFTs' as label from fish_whale where number >= 70 and number < 80 UNION select count(1) as datas,'j.Users staked between 80 to 90 NFTs' as label from fish_whale where number >= 80 and number < 90 UNION select count(1) as datas,'k.Users staked between 90 to 100 NFTs' as label from fish_whale where number >= 90 and number < 100 UNION select count(1) as datas,'l.Users staked above 100 NFTs' as label from fish_whale where number >= 100 order by label

Aurory Expeditions