with fees as (select TX_GROUP_ID as group_,*
from algorand.payment_transaction
where receiver = 'XNFT36FUCFRR6CK675FW4BEBCCCOJ4HOSMGCN6J2W6ZMB34KM2ENTNQCP4'
)
select sum(amount) as total_algo, count(TX_GROUP_ID) as total_number_sales
from algorand.payment_transaction
where TX_GROUP_ID in ( select group_ from fees) and block_timestamp::date >= '2022-01-01'