b.TOKEN_METADATA_URI as NFT_IMAGE_URI,

count(distinct a.TX_ID) as "NUMBER OF TRANSACTIONS"

FROM solana.core.fact_nft_sales a

JOIN solana.core.dim_nft_metadata b

ON a.MINT = b.MINT

where a.SALES_AMOUNT > 0 AND a.SALES_AMOUNT is not null

AND LOWER(b.CONTRACT_NAME) = LOWER('DeGods')

AND a.succeeded = 'TRUE'

group by 1, 2

order by 3 DESC

LIMIT 5