madhurim2023-11-18 07:50 PM
    SELECT
    SUM(s.total_fees) AS Total_fees, SUM(s.total_fees_usd) AS Total_fees_dollar,
    SUM (s.creator_fee) AS Creator_fee,
    SUM (s.creator_fee_usd) AS Creator_fee_dollar
    FROM
    ethereum.nft.dim_nft_metadata AS m, ethereum.nft.ez_nft_sales AS s
    WHERE
    m.project_name LIKE ('%art%blocks')
    AND m.token_name LIKE ('%fidenza%')
    AND s. tokenid = m. token_id
    AND s.platform_name LIKE ('opensea')
    AND s.block_timestamp BETWEEN '{{start_date}}'
    AND '{{end_date}}';
    Run a query to Download Data