SELECT

count(DISTINCT payer) as flow_transactors

from

flow.core.fact_transactions

where

block_Timestamp >= CURRENT_DATE - 90

),

flow_swaps as (

SELECT

count(DISTINCT trader) as flow_swappers

from

flow.core.fact_swaps

where

block_Timestamp >= CURRENT_DATE - 90

),

flow_nft_sales as (

SELECT

count(DISTINCT buyer) as flow_nft_buyers

from

flow.core.fact_nft_sales

where

block_Timestamp >= CURRENT_DATE - 90

),

flow as (

SELECT

*,

flow_swappers / flow_transactors * 100 as percent_swappers_flow,

flow_nft_buyers / flow_transactors * 100 as percent_nft_buyer_flow

from

flow_nft_sales,

flow_swaps,

flow_txs

),

sol_txs as (

SELECT