case when tx.asset_id = '386192725' then 'goBTC'else 'goETH' end as "Asset Name",

COUNT(DISTINCT asset_receiver) as "Number of Wallets",sum(ASSET_AMOUNT/ power(10,algoasset.decimals)) as "Total Amount"

from algorand.asset_transfer_transaction as tx ,algorand.asset as algoasset

WHERE sender = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4' and tx.asset_id in (386195940,386192725)

and algoasset.asset_id=tx.asset_id

GROUP BY tx.asset_id