select

concat('Ethereum') as chain,

count(tx_hash)/9 as avg_sales -- divided by 9 months

from ethereum.core.ez_nft_sales

where block_timestamp >= '2022-01-01'

and block_timestamp < '2022-10-01'

),

solana as (

select

concat('Solana') as chain,

count(tx_id)/9 as avg_sales -- divided by 9 months

from solana.core.fact_nft_sales

where block_timestamp >= '2022-01-01'

and block_timestamp < '2022-10-01'

),

flow as (

select

concat('Flow') as chain,

count(tx_id)/9 as avg_sales -- divided by 9 months

from flow.core.ez_nft_sales

where block_timestamp >= '2022-01-01'

and block_timestamp < '2022-10-01'

select *

from ethereum

union

select *

from solana

union

select *

from flow