select

block_timestamp,

tx_hash,

from_address

from aurora.core.fact_transactions

where tx_fee = 0

and gas_price = 0

and status = 'SUCCESS'

),

aurora_plus_users_first_transactions as (

select

from_address,

min(block_timestamp) as first_transactions_date

from aurora_plus_users_transactions

group by from_address

having first_transactions_date >= '2022-05-17'

),

aurora_plus_users_transactions_2 as (

select

from_address,

count(distinct tx_hash) as number_of_transaction

from aurora_plus_users_transactions transactions

where from_address in (select from_address from aurora_plus_users_first_transactions)

group by from_address

having number_of_transaction > 1

select

count(distinct from_address) as "Total Users",

count(distinct tx_hash) as "Total Transactions"

from aurora_plus_users_transactions

join aurora_plus_users_transactions_2 using(from_address)

where block_timestamp::date >= '2023-07-20'