JimMyersTechminter profiles: other chains 90 days copy
    -- forked from theericstone / minter profiles: other chains 90 days @ https://flipsidecrypto.xyz/theericstone/q/lRKapgZu71qy/minter-profiles-other-chains-90-days

    with nftaddys as (
    select nft_address, count(1)
    from base.core.ez_nft_transfers
    where project_name = '{{project}}'
    group by 1
    ),

    minters as (
    select
    nft_to_address as minter,
    count(distinct(tx_hash)) as n_mints
    from base.core.ez_nft_transfers
    where nft_address in ( select nft_address from nftaddys )
    and event_type = 'mint'
    group by 1
    ),

    select
    DISTINCT
    address,
    blockchain,
    n_mints
    from crosschain.core.address_tags tags
    join minters on minters.minter = tags.address
    where end_date IS NULL
    or start_date > current_date() - 90;



    Run a query to Download Data