select

mint

from solana.core.dim_nft_metadata

where project_name = 'SOLGods'

),

buyers as (

select

date_trunc('month', sales.block_timestamp) as month,

count(distinct(sales.seller)) as address

from solana.core.fact_nft_sales as sales

inner join solgods on sales.mint = solgods.mint

group by month

select *

from buyers