Query editor
withmean as (SELECTday, MIN(mean_of_all_narrative) as mean_of_all_narrative, MIN(btc_growth) as btc_growth, MIN(eth_growth) as eth_growthFROM query_3840517GROUP BY 1ORDER BY 1 DESC)SELECTday, mean_of_all_narrative, btc_growth, mean_of_all_narrative / btc_growth as btc_indicator, CASE WHEN mean_of_all_narrative / btc_growth > 1 THEN 'OUT PERFORMING'ELSE 'UNDER PERFORMING'END AS allcoins_againts_btc, eth_growth, mean_of_all_narrative / eth_growth as eth_indicator, CASE WHEN mean_of_all_narrative / eth_growth > 1 THEN 'OUT PERFORMING'ELSE 'UNDER PERFORMING'END AS allcoins_againts_ethFROM meanORDER BY 1 DESC