select

date_trunc('month', block_timestamp) as time,

platform_name,

sum(CASE WHEN creator_fee_usd > 0 THEN 1 ELSE 0 END) AS n_tx_royalty_payment,

sum(creator_fee_usd) as royalty_fees,

sum(platform_fee_usd) as platform_fees

from ethereum.nft.ez_nft_sales

where currency_symbol in ('ETH','WETH')

and block_timestamp > '2022-10-01'

and price_usd < 1000000

and platform_name in ('blur','opensea')

group by 1,2