Updated 2022-10-02
    with traits as (
    --query "Nouns Mints + Meta" by erics https://app.flipsidecrypto.com/velocity/queries/1ee22900-7e0a-464a-b9a4-707dab0dbc63
    select TOKEN_ID as tokenid ,contract_address,
    TOKEN_METADATA: background as Backgrounds ,
    (TOKEN_METADATA:body) body ,--IS NOT NULL THEN TOKEN_METADATA:Clothes ELSE '0' END as Clothess,
    TOKEN_METADATA:face face,-- IS NOT NULL THEN TOKEN_METADATA:Earring ELSE '0' END AS Earrings,
    TOKEN_METADATA:hair as hair,
    TOKEN_METADATA:head as head,
    TOKEN_METADATA:piercing as piercing
    from ethereum.core.dim_nft_metadata where lower(CONTRACT_ADDRESS) =lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
    order by tokenid desc
    ),
    mint_1 as (
    SELECT
    tx_hash,
    tokenid
    FROM ethereum.core.ez_nft_mints
    WHERE lower(nft_address) =lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
    ),

    mint_2 as (
    select
    tx_hash,
    amount as mint_price_eth
    from ethereum.core.ez_eth_transfers
    where lower(eth_from_address) =lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
    ),

    mint_price as (
    select
    mint_1.tx_hash,
    mint_1.tokenid,
    mint_2.mint_price_eth
    from mint_1
    Run a query to Download Data