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'

and first_transactions_date < '2023-07-20'

),

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

),

aurora_plus_users_transactions_3 as (

select

from_address as "User",

count(distinct block_timestamp::date) as "Duration of Stay in Aurora (Days)"

from aurora_plus_users_transactions

where from_address in (select from_address from aurora_plus_users_transactions_2)

and block_timestamp::date >= '2022-05-17'

and block_timestamp::date < '2023-07-20'