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