mohamadreza221166Total Degods Nft Sales By Collection
    Updated 2023-04-13
    SELECT T2.ADDRESS_NAME AS nft_collection, sum(SALES_AMOUNT) AS sale_amount,
    COUNT(DISTINCT MINT) unique_nft, COUNT(*) number_of_sales
    FROM solana.core.fact_nft_sales T1
    JOIN solana.core.dim_labels T2 ON T2.ADDRESS = T1.MINT
    WHERE lower(ADDRESS_NAME) LIKE '%degods%'
    GROUP BY 1
    ORDER BY 2 DESC

    Run a query to Download Data