a as

(SELECT

count (DISTINCT tx_signer) as users

from near.core.fact_transactions

where tx_receiver ='x.paras.near'

or tx_receiver ='marketplace.paras.near')

,b as (

SELECT

count (DISTINCT tx_hash) as trxs

from near.core.fact_transactions

where tx_receiver ='x.paras.near'

or tx_receiver ='marketplace.paras.near'

and tx_status='Success')

,c as (

SELECT

sum (gas_used/10000000000000000) as total_gas

from near.core.fact_transactions

where tx_receiver ='x.paras.near'

or tx_receiver ='marketplace.paras.near'

and tx_status='Success')

select