select

distinct minter as minter,

count(badge_id) as minted_badges,

sum(amount_minted) as amount_minted

from

(

select

decoded_log ['to'] as minter,

decoded_log ['id'] as badge_id,

decoded_log ['amount'] as amount_minted

from

berachain.testnet.fact_decoded_event_logs

where

CONTRACT_ADDRESS = lower('0x886D2176D899796cD1AfFA07Eff07B9b2B80f1be')

and decoded_log ['from'] = lower('0x0000000000000000000000000000000000000000')

)

group by 1

select ROW_NUMBER() OVER (order by minted_badges desc) as rank, minter,minted_badges from badge_minters

order by rank