select

RECEIVER as claimer,

sum(AMOUNT/1e6) as total_claimed,

min(BLOCK_TIMESTAMP) as first_claim_timestamp

from lava.core.fact_transfers

where SENDER = 'lava@188kzvhru5ch303a2h78a2kya9dp7gup9fkpd2t'

and TRANSFER_TYPE = 'LAVA'

and TX_SUCCEEDED = 'TRUE'

group by RECEIVER

select

count(distinct claimer) as total_airdrop_claimers,

sum(total_claimed) as total_airdrop_claimed

from airdrop_claims;