avg(total_user) as average_user,

avg(total_transaction) as average_transaction

FROM (

SELECT date(block_timestamp) as date,

count(DISTINCT origin_from_address) as total_user,

count(DISTINCT tx_hash) as total_transaction

FROM avalanche.core.fact_token_transfers

LEFT outer JOIN avalanche.core.dim_labels

ON contract_address = address

WHERE block_timestamp > '2022-07-01'

AND contract_address LIKE lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E')

AND origin_from_address = from_address

group by 1