Query editor
-- Daily Claims by ChainWITH all_claims AS (SELECT * FROM query_6325907UNION ALLSELECT * FROM query_6326470UNION ALLSELECT * FROM query_6326500UNION ALLSELECT * FROM query_6326514)SELECTdate,chain,SUM(num_claims) as total_claims,SUM(total_claimed) as total_fluid_claimedFROM all_claimsWHERE exclude_expense = falseGROUP BY 1, 2ORDER BY date DESC, chain