with mint_holders as (

select

NFT_TO_ADDRESS as Minter,

ens_name as ENS,

count(ezm.tx_hash) as Mad_Boys_Minted

from ethereum.core.ez_nft_mints ezm

left join crosschain.core.ez_ens ens on ezm.nft_to_address = ens.owner

and ens.ens_set ='Y'

where ezm.nft_address = '0x2c41a1f838f74e4389392dff3d5f21b272a48a8f'

group by Minter, ens_name

),

total_mints as (

select count(tx_hash) as Total_Minted

from ethereum.core.ez_nft_mints ezm

where ezm.nft_address = '0x2c41a1f838f74e4389392dff3d5f21b272a48a8f'

select

Minter,

ENS,

Mad_Boys_Minted,

(Mad_Boys_Minted / Total_Minted) * 100 as Percent_of_Total_Mints

from mint_holders

inner join total_mints on 1 = 1

order by Percent_of_Total_Mints desc