from gnosis.core.fact_transactions

group by 1

order by 1)

select user_

from tab1

where First_Tx_date<'2022-10-05'),

table2 as (select block_timestamp::date as date, from_address, count(distinct tx_hash) as tx_count, to_address, status

from gnosis.core.fact_transactions

where block_timestamp::date='2022-10-05'

group by 1,2,4,5)

select sum(tx_count) as "Tx Count", status

from table1 left join table2 on table1.user_=table2.from_address

where status is not null and to_address='0xc38d4991c951fe8bce1a12beef2046ef36b0fa4a'

group by 2