merge into fatliver f
using (select id, case when drink = '음주많음' and smoking = '흡연' then 1
else 0 end as smoke_drink
from fatliver )z
on (f.id = z.id)
when matched then
update set f.smoke_drink = z.smoke_drink;
--------------------------------------------------------------------
update (select smoke_drink, case when drink = '음주많음' and smoking = '흡연' then 1
else 0 end as z
from fatliver )
set smoke_drink = z;