FAILED: Error in semantic analysis: Line 1:19 Argument type mismatch 2.0: The expressions after COALESCE should all have the same type: "int" is expected but "double" is found