SELECT

Chain,

AVG(Active_Users) AS average_active_users

FROM

(

SELECT

'Base' AS Chain, COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Active_Users

FROM

base.nft.ez_nft_sales

GROUP BY 1

UNION ALL

SELECT

'Ethereum' AS Chain, COUNT(DISTINCT From_Address) AS Active_Users

FROM

ethereum.core.fact_transactions

GROUP BY 1

UNION ALL

SELECT

'Optimism' AS Chain, COUNT(DISTINCT From_Address) AS Active_Users

FROM

optimism.core.fact_transactions

GROUP BY 1

UNION ALL

SELECT

'Arbitrum' AS Chain, COUNT(DISTINCT From_Address) AS Active_Users

FROM

arbitrum.core.fact_transactions

GROUP BY 1

) AS activities

GROUP BY Chain

SELECT

Chain,

average_active_users

FROM