s.purchaser,

count(s.purchaser) as "Count of Degods NFT"

from solana.fact_nft_sales s join solana.dim_nft_metadata d on s.mint = d.mint

where s.block_timestamp::date > CURRENT_DATE - 180

and d.creator_name = 'DeGods'

and s.marketplace = 'magic eden v1' and s.succeeded = 'True'

group by 1

order by 2 DESC

LIMIT 20