Query editor
WITH esipher_claimed AS (SELECT"to" AS wallet,SUM(CAST(value AS DOUBLE) / 1e18) AS esipher_claimedFROMerc20_ethereum.evt_TransferWHEREcontract_address = 0xb2d1464ae4cc86856474a34d112b4a2efa326ed9AND "from" = 0x0000000000000000000000000000000000000000AND "to" IN (0xd53ec61b787689b29e67b98ee2d0a57cbba060d8,0x92d899e0e47ccfe4571527d03dc7fe8aa08968f3,0xc90ea4d8d214d548221ee3622a8be1d61f7077a2,0xe6a74168057f5f01537adc4c1eaf840c1877eb0b)AND evt_block_time <= CAST('2022-12-31' AS TIMESTAMP)GROUP BY1),esipher_vested AS (SELECT"from" AS wallet,SUM(CAST(value AS DOUBLE) / 1e18) AS esipher_vestedFROMerc20_ethereum.evt_TransferWHEREcontract_address = 0xb2d1464ae4cc86856474a34d112b4a2efa326ed9AND "to" = 0x0000000000000000000000000000000000000000AND "from" IN (0xd53ec61b787689b29e67b98ee2d0a57cbba060d8,0x92d899e0e47ccfe4571527d03dc7fe8aa08968f3,0xc90ea4d8d214d548221ee3622a8be1d61f7077a2,0xe6a74168057f5f01537adc4c1eaf840c1877eb0b)GROUP BY1)SELECTesipher_claimed.wallet,esipher_vested.esipher_vested,esipher_claimed.esipher_claimed,esipher_claimed.esipher_claimed - esipher_vested.esipher_vested AS unclaimed_amount,esipher_vested.esipher_vested / esipher_claimed.esipher_claimed AS percentageFROMesipher_claimedLEFT JOIN esipher_vested ON esipher_claimed.wallet = esipher_vested.walletORDER BYesipher_claimed DESC NULLS FIRST