SELECT
SUM(asset_amount)/1000000,
asset_receiver
FROM
algorand.asset_transfer_transaction
WHERE
(
asset_id = '27165954'
)
AND
sender = 'ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754'
AND
asset_amount IS NOT NULL
GROUP BY asset_receiver
ORDER BY SUM(asset_amount) DESC
LIMIT 10