Query editor
with bgt_issued as(select sum(value/1e18) as amountfrom berachain_berachain.bgt_evt_transfer twhere t."from" = 0x0000000000000000000000000000000000000000),bgt_redeemed as(select sum(value/1e18) as amountfrom berachain_berachain.bgt_evt_transfer twhere t."to" = 0x0000000000000000000000000000000000000000),bgt_price as (select avg(price) as price from query_4725925)select t.amount as bgt_issued,a.amount as bgt_redeemed,(t.amount-a.amount) as bgt_supply,(t.amount-a.amount)*p.price as bgt_supply_valuefrom bgt_issued t, bgt_redeemed a,bgt_price p