select sum(column1) , SUM(column2), sum(column1)/ SUM(column2) , (sum(column1) + SUM(column2)) as aliasColumn from datasource where AND __time>=‘2020-06-30T00:00:00’ and __time<=‘2020-07-30T00:00:00’ GROUP BY columnId
Above query when executed returns 1,3,0,4 respectively when it should have been 1,3,1/3,4 respectively .
Any reason why its behaving that way? Have attached the screenshot of the result too.
Thanks in advance