Query editor
SELECTtvl.dapp,sumTradingFees,medianTvl,sumVolume,medianUAWFROM(SELECTitem AS dapp,approx_percentile(value, 0.5) as medianTvlFROM dune.fidi.dotsightWHEREtype = 'beta-network'AND metric = 'Total Value Locked'GROUP BYitem) tvl LEFT JOIN (SELECTitem AS dapp,SUM(value) as sumTradingFeesFROM dune.fidi.dotsightWHEREtype = 'beta-network'AND metric = 'Trading Fees'GROUP BYitem) fee ON fee.dapp = tvl.dapp LEFT JOIN (SELECTitem AS dapp,SUM(value) as sumVolumeFROM dune.fidi.dotsightWHEREtype = 'beta-network'AND metric = 'Trading Volume'GROUP BYitem) volume ON volume.dapp = tvl.dapp LEFT JOIN (SELECTitem AS dapp,approx_percentile(value, 0.5) as medianUAWFROM dune.fidi.dotsightWHEREtype = 'beta-network'AND metric = 'Interacted Unique Active Wallets'GROUP BYitem) uaw ON uaw.dapp = volume.dapp