WITH dummy AS (
select *
from unnest(sequence(0, 100, 10), sequence(100, 200, 10)) t(a1, a2)
)
SELECT
a1,
a2,
a1/a2 AS origin_divide,
CAST(a1 AS double)/CAST(a2 AS double) AS ASIS,
"a1"*1e0 / "a2"*1e0 AS TOBE, -- "컬럼명"에 쌍따옴표를 하는 이유는 1e0 곱할시 혼동이 될까해서 추가.
a1*1e0/a2*1e0 AS TOBE2 -- 쌍따옴표를 안해도 동일한 결과.
FROM dummy