TX_RECEIVER RECEIVER,

COUNT(DISTINCT(TX_HASH)) TX_NUM,

SUM(DEPOSIT)/POWER(10,24) TOTAL_TRANSFERED

FROM near.core.fact_transfers

WHERE STATUS = 1

AND tx_signer = 'sweat_welcome.near'

GROUP BY RECEIVER

ORDER BY TOTAL_TRANSFERED DESC, TX_NUM ASC