Question 92

Why do I need to multiply column with 1.0 to perform result?

Below code works:

SELECT sum(case when acceptance_dt is not null then 1 else 0 end)*1.0/count(*) as acceptance_rate

FROM request

where date(request_dt)>='2021-01-01'
AND date(request_dt)<='2021-01-07'
;

However below code returns "0" as result, why?

SELECT sum(case when acceptance_dt is not null then 1 else 0 end)/count(*) as acceptance_rate

FROM request

where date(request_dt)>='2021-01-01'
AND date(request_dt)<='2021-01-07'
;