SELECT tx_from AS address

, SUM(-amount) AS net_amt

FROM solana.core.fact_transfers

WHERE block_timestamp >= '2022-12-14'

AND mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

GROUP BY 1

UNION

SELECT tx_to AS address

, SUM(amount) AS net_amt

FROM solana.core.fact_transfers

WHERE block_timestamp >= '2022-12-14'

AND mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

GROUP BY 1

UNION

SELECT '9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw' AS address

, POWER(10, 14) AS net_amt

), t1 AS (

SELECT address

, SUM(net_amt) AS net_amt

FROM t0

GROUP BY 1

SELECT address, net_amt AS amount, ROUND(100 * net_amt / SUM(net_amt) OVER (), 2) AS pct

FROM t1

WHERE net_amt >= 1 and address not in ('DBR2ZUvjZTcgy6R9US64t96pBEZMyr9DPW6G2scrctQK',

'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p', '6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p',

'GYqXgEqjcthrFGJZaB4v9D6p4F7a1PKKJZeASfZWb2GH')

ORDER BY net_amt DESC limit 100