from sei.core.fact_msg_attributes

where attribute_value = 'sei1cujl8ujhc36lp7sr98x30u0aeqtjlj68kll5rqqr9dke5xvn2ltquzhysl'

and attribute_key = 'collection'

and block_timestamp::date >= '2024-02-08'

and tx_id in (select tx_id from sei.core.fact_msg_attributes

where attribute_value = 'mint'

and attribute_key = 'action'

and block_timestamp::date >= '2024-02-08'))

,

fee as ( select block_timestamp, split(fee,'usei')[0]/pow(10,6) as fees

from sei.core.fact_transactions

where tx_id in (select tx_id from hash))

select

sum(fees) as total_fee,

avg(fees) as avg_fee

from fee

where fees < 1