-- forked from Day 8 NFTs @ https://flipsidecrypto.xyz/edit/queries/74c65415-7e01-412d-a524-a1a675f636ed
with mints as (
select * from base.core.ez_nft_transfers
where nft_address in (
'0x9d9c0c4e764117fccd2bc3548f0e95c806e6f996')
and event_type = 'mint')
select
project_name as Quest_NFT,
count(distinct nft_to_address) as Unique_minters,
count(tx_hash) as Total_mints,
Total_mints * 0.000777 as Earnings
from mints
group by 1