platform_name,

row_number() over (order by transaction_volumes desc ) as rankings

from (select platform_name,

count(1) as transaction_counts,

count(distinct seller_address) as sellers,

count(distinct buyer_address) as buyers,

sum(price_usd) as transaction_volumes

from ethereum.core.ez_nft_sales

where block_timestamp >= '2022-10-19'

group by 1) as tmp

order by 3