date_trunc(week,block_timestamp)::date as weeks,

y.team,

count(distinct BUYER) as buyer_count,

row_number()over(partition by weeks order by buyer_count desc) as n

from flow.core.fact_nft_sales x left outer join flow.core.dim_topshot_metadata y on x.NFT_ID=y.NFT_ID

where TX_SUCCEEDED='TRUE'

and x.NFT_COLLECTION='A.0b2a3299cc857e29.TopShot'

and team is not null

group by 1,2

qualify n <= 5