select f."fees paid (ALGO)", t."transactions", f."address" from(
select sum(FEE) as "fees paid (ALGO)", SENDER as "address"
from flipside_prod_db.algorand.transactions
where BLOCK_TIMESTAMP between '2022-01-01' and '2022-06-06' and FEE is not null
group by 2
order by 1 desc
limit 20) as f
inner join(
select count(*) as "transactions", SENDER as "address"
from flipside_prod_db.algorand.transactions
where BLOCK_TIMESTAMP between '2022-01-01' and '2022-06-06'
group by 2) as t
on t."address" = f."address"
order by 1 desc