count(distinct tx_id) as txns_count,

count(distinct (iff(transfer_type = 'IBC_TRANSFER_IN', tx_id, null))) as inflow_txns_count,

count(distinct (iff(transfer_type = 'IBC_TRANSFER_OUT', tx_id, null))) as outflow_txns_count,

count(distinct sender) as senders_count,

count(distinct receiver) as receivers_count,

txns_count / senders_count as txns_per_user

from osmosis.core.fact_transfers

where tx_succeeded = 1

and block_timestamp > current_date - 90