COUNT(distinct buyer) as whale_numbers,

sum(volume) as volume,

sum(sale_count)as sales_number

FROM (

select top 100

buyer,

count(DISTINCT tx_id) as sale_count,

sum(price) as volume,

'flow' AS chain

from flow.core.fact_nft_sales

group by 1, 4

order by 3 desc

)

GROUP by 1