select

origin_from_address as address,

count(distinct(tx_hash)) as tx_num,

sum(event_inputs:value / pow(10, 18)) as total_amount

from ethereum.core.fact_event_logs

where origin_function_signature in ('0xeb4d6138')

and origin_to_address = '0x1a9a4d919943340b7e855e310489e16155f4ed29'

and contract_address = '0xb3999f658c0391d94a37f7ff328f3fec942bcadc'

and block_timestamp >= '2022-11-07 12:31:00.000'

and block_timestamp::date = '2022-11-07'

and tx_status = 'SUCCESS'

group by address

having total_amount > 0

)

select

case

when total_amount < 585 then 'Hashbot Poster #1'

when total_amount <= 1872 then 'Hashbot Poster #2'

when total_amount <= 4457 then 'The Hashbot #1 Page 1 & 3, Poster #3 & 4'

when total_amount <= 13637 then 'The Hashbot #1 Page 4'

when total_amount <= 30001 then 'THashbot: Domination'

else null

end as ratio_of_each_nft,

count(distinct(address)) as claimers_num

from claim

group by ratio_of_each_nft

having ratio_of_each_nft is not null

order by claimers_num desc