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'
AND
amount > 0
AND
amount < 20999850187708
GROUP BY asset_id, asset_name
Order by wallets DESC