with t1 as(select

tx_group_id

from algorand.payment_transaction

where RECEIVER='XNFT36FUCFRR6CK675FW4BEBCCCOJ4HOSMGCN6J2W6ZMB34KM2ENTNQCP4'

select

count(*) as total_sale,

sum(AMOUNT) as total_algo

from algorand.payment_transaction

where tx_group_id in (select tx_group_id from t1)

and RECEIVER!='XNFT36FUCFRR6CK675FW4BEBCCCOJ4HOSMGCN6J2W6ZMB34KM2ENTNQCP4'

and BLOCK_TIMESTAMP>='2022-01-01'