x as (

select

column1 as i,

column2 as v

from

values

(1.1, 1),

(2, 0),

(1.12, 12),

(1.11, 11),

(0.8, 8),

(1.8, 8),

(0.12, 12),

(1.2, 2),

(0.4, 4),

(3.7, 7),

(3.12, 12),

(2.10, 10),

(2.1, 1),

(4.0, 0),

(4, 0)

as vals

)

i,

i::string,

i::float,

i::number,

i::float::string as j,

split(j, '.'),

split(i, '.') as x,

split_part(i::float, '.', 1)::int as num,

case

when contains(i::float::string, '.') then split_part(i::float, '.', 2)::int

else 0