from sei.core.fact_msg_attributes

where attribute_value='sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

and attribute_key='_contract_address'

and msg_type='wasm-execute-exchange'

and tx_succeeded='true'),

tab2 as (select block_timestamp::date as "Date", tx_id, tx_from, split_part(fee,'u',1)/pow(10,6) as fee

from sei.core.fact_transactions)

select sum(fee) as "Fee (SEI)", avg(fee) as "Average Fee per TX", MAX(fee) as "Max Fee paid", median(fee) as "Median Fee per TX",

sum(fee)/count(distinct tx_from) as "Avg Fee per Buyer"

from tab1 left join tab2 on tab1.tx_id=tab2.tx_id

where "Date">='2023-09-01'