select asset_name, sum(fee) as fees, count(tx_id) as transactions from flipside_prod_db.algorand.asset_transfer_transaction
inner join algorand.asset on algorand.asset.asset_id = algorand.asset_transfer_transaction.asset_id
where fee is not null
group by 1
order by 2 desc
limit 10