count(DISTINCT a.tx_id) as transactions,

count(DISTINCT attribute_value) as DAU,

transactions/DAU as avg_tx_per_user

from sei.core.fact_msg_attributes a left outer join sei.core.fact_transactions b on a.tx_id = b.tx_id

where attribute_key in ('sender','fee_payer','recipient','receiver')

and attribute_value not in (select attribute_value

from sei.core.fact_msg_attributes

where attribute_key ilike '%contract_address%'

and block_timestamp::date >= '2023-08-15')

and FEE != '0usei'

and a.block_timestamp::date >= '2023-08-15'

group by 1