-- forked from Bridge to Base NFT #1 quest Totals @ https://flipsidecrypto.xyz/edit/queries/b1903ab4-23a4-4c2d-b07a-d93fa3b0443b

with mints as (

select * from base.core.ez_nft_transfers

where nft_address = '0x874ad7c13935f73c7bbe94efbd8e766de2a585eb'

and event_type = 'mint')

project_name as Quest_NFT,

count(distinct nft_to_address) as Unique_minters,

count(tx_hash) as Total_mints,

Total_mints * 0.00435 as Earnings

from mints

group by 1