Query editor
SELECTtxs.category,medianTxsCount,medianGasSpent,medianFees,medianUAWFROM (SELECTitem AS category,approx_percentile(value, 0.5) as medianTxsCountFROM dune.fidi.dotsightWHEREtype = 'dapp-group'AND metric = 'Total Transactions'GROUP BYitem) txs LEFT JOIN (SELECTitem AS category,approx_percentile(value, 0.5) as medianGasSpentFROM dune.fidi.dotsightWHEREtype = 'dapp-group'AND metric = 'Total Gas Spent'GROUP BYitem) gas ON gas.category = txs.category LEFT JOIN (SELECTitem AS category,approx_percentile(value, 0.5) as medianFeesFROM dune.fidi.dotsightWHEREtype = 'dapp-group'AND metric = 'Total Transaction Fees'GROUP BYitem) fee ON gas.category = fee.category LEFT JOIN (SELECTitem AS category,approx_percentile(value, 0.5) as medianUAWFROM dune.fidi.dotsightWHEREtype = 'dapp-group'AND metric = 'Interacted Unique Active Wallets'GROUP BYitem) uaw ON uaw.category = gas.category