SELECT

count(DISTINCT signers[0]) as sol_transactors

from

solana.core.fact_transactions

where

block_Timestamp >= CURRENT_DATE - 90

),

sol_swaps as (

SELECT

count(DISTINCT swapper) as sol_swappers

from

solana.core.fact_swaps

where

block_Timestamp >= CURRENT_DATE - 90

),

sol_nft_sales as (

SELECT

count(DISTINCT purchaser) as sol_nft_buyers

from

solana.core.fact_nft_sales

where

block_Timestamp >= CURRENT_DATE - 90

),

solana as (

SELECT

*,

sol_swappers / sol_transactors * 100 as percent_swappers_sol,

sol_nft_buyers / sol_transactors * 100 as percent_nft_buyer_sol

from

sol_nft_sales,

sol_swaps,

sol_txs

),

eth_txs as (

SELECT