24Spring554_team12#4 secondary sales
    Updated 2024-04-12
    SELECT
    COUNT(*) as total_secondary_sales,
    SUM(PRICE) as total_sales_in_eth,
    SUM(PRICE_USD) as total_sales_in_usd,
    SUM(CREATOR_FEE) as creator_commission_in_eth,
    SUM(CREATOR_FEE_USD) as creator_commission_in_usd
    FROM
    ethereum.nft.ez_nft_sales
    WHERE
    NFT_ADDRESS = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
    AND TOKENID LIKE '78000___'
    AND SELLER_ADDRESS != '0x33c9371d25ce44a408f8a6473fbad86bf81e1a17';
    QueryRunArchived: QueryRun has been archived