WITH t0 AS (

SELECT tx_from AS address

, SUM(-amount) AS net_amt

FROM solana.core.fact_transfers

WHERE block_timestamp >= '2022-12-14'

AND mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'

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 = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'

GROUP BY 1

), t1 AS (

SELECT address

, SUM(net_amt) AS net_amt

FROM t0

GROUP BY 1

SELECT

CASE

WHEN address='DLzPkF5UuNKhQgtMFh2cu5U6aYji5YKyqMiBpYCMKy4R' THEN 'WEN treasury'

WHEN address='3kXVTiiU6sv9mnE9w6jrbFcqBCLBEFB9f7xyuGM4xz8b' THEN 'Jupiter'

WHEN address='C4679ZqtJhRqQP5fq1GVHdbxmG1eMeUu98kMMYDZGVyQ' THEN 'Meteora'

WHEN address='DdwKGvapP14467yE49omjz7i5zVBS43BofBdGLE1To34' THEN 'Meteora'

WHEN address='ASTyfSima4LLAdDgoFGkgqoKowG1LZFDr9fAQrg7iaJZ' THEN 'MEXC'

ELSE address

END as "Address"

, to_varchar(net_amt, '999,999,999,999,999') AS "Total amount"

, CONCAT(ROUND(100 * net_amt / SUM(net_amt) OVER (), 4), '%') AS "Percent"

FROM t1