with a as ( Select

EVENT_DATA:"from" as user,

min(block_timestamp) as first_transaction_stamp

from flow.core.fact_events

where TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP::date>='2022-08-01' and BLOCK_TIMESTAMP::date<='2022-08-10' group by 1)

,

b as ( Select

EVENT_DATA:"from" as user,

min(block_timestamp) as second_transaction_stamp

from flow.core.fact_events m join a on a.user=m.EVENT_DATA:"from"

where TX_SUCCEEDED='TRUE'

and block_timestamp>first_transaction_stamp group by 1)

select e.EVENT_CONTRACT,

count(b.user) as num_new_users

from flow.core.fact_events e join b on (b.user=e.EVENT_DATA:"from" )

group by 1

order by 2 desc

select * from flow.core.fact_events

where EVENT_TYPE like '%AccountCreated%'

and EVENT_CONTRACT='flow'

and block_timestamp::date>='2022-08-11'

limit 15

select * from flow.core.dim_contract_labels where CONTRACT_NAME like '%Dapper%' limit 4

with a as(

select * from flow.core.fact_events

where EVENT_CONTRACT='A.0b2a3299cc857e29.TopShot'