SELECT
asset_name AS ASA,
asset_id,
COUNT(DISTINCT(address)) AS wallets,
sum(amount)/1000000 AS Total_amount
FROM
algorand.account_asset
WHERE
asset_id IS NOT NULL
AND
(asset_id = '465865291' or asset_id = '31566704' or asset_id = '312769')
AND
amount > 0
AND
amount < 20999850187708
GROUP BY asset_id, asset_name
Order by wallets DESC