Query editor
SELECTexchange,ROUND(SUM(CASE WHEN day >= CURRENT_DATE - INTERVAL '7' DAY THEN inflow_m_usd ELSE 0 END), 2) AS inflow_7d_m,ROUND(SUM(CASE WHEN day >= CURRENT_DATE - INTERVAL '7' DAY THEN outflow_m_usd ELSE 0 END), 2) AS outflow_7d_m,ROUND(SUM(CASE WHEN day >= CURRENT_DATE - INTERVAL '7' DAY THEN netflow_m_usd ELSE 0 END), 2) AS netflow_7d_m,ROUND(SUM(inflow_m_usd), 2) AS inflow_30d_m,ROUND(SUM(outflow_m_usd), 2) AS outflow_30d_m,ROUND(SUM(netflow_m_usd), 2) AS netflow_30d_mFROM query_9163898GROUP BY 1ORDER BY netflow_7d_m DESC