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