select * from flipside_prod_db.algorand.labels

where label_type = 'cex'

and label_subtype = 'hot_wallet'

select label, count(*) as transactions from cexs join flipside_prod_db.algorand.payment_transaction p_transactions on cexs.address = p_transactions.receiver

group by label

order by transactions desc