with raw as (select block_timestamp as t,tx_hash, event_inputs:label as ens_id,event_inputs:name as ens_label, event_inputs:cost/10e17 as mint_cost, length(ens_label) as len

from ethereum.core.fact_event_logs

where event_name = 'NameRegistered' and origin_to_address = '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5' and event_inputs:name is not null),

raw2 as (select * from (select * from raw

where len=3 )

where regexp_like(ens_label, '^[0-9]*$'))

select * from ethereum.core.ez_nft_sales

where project_name ='ens' and event_type = 'sale'

limit 100