--smoke_drink 컬럼 생성
alter table fatliver
add smoke_drink number(10);
--smoke_drink 값 갱신
merge into fatliver f
using (select id, case when drink = '음주많음' and smoking = '흡연' then 1
else 0 end as sd
from fatliver) f2
on (f.id = f2.id)
when matched then
update set f.smoke_drink = f2.sd;
--smoke_drink 값 확인
select * from fatliver;