SELECT
asset_name AS ASA,
asset_id,
COUNT(DISTINCT(address)) AS wallets
FROM
algorand.account_asset
WHERE
asset_id IS NOT NULL
AND
(
asset_id = '226701642' OR
asset_id = '287867876' OR
asset_id = '27165954' OR
asset_id = '137594422' OR
asset_id = '384303832' OR
asset_id = '230946361' OR
asset_id = '297995609' OR
asset_id = '300208676' OR
asset_id = '31566704' OR
asset_id = '312769'
)
GROUP BY asset_id, asset_name
Order by wallets DESC
Limit 10