
4-8 실습 문의드립니다!
case when price <=5000 then 'price_group1'
when price <=10000 then 'price_group2'
when price <=30000 then 'price_group3'
when price >30000 then 'price_group4' end price_group,
case when age <30 then 'age_group1'
when age <40 then 'age_group2'
when age <50 then 'age_group3'
else 'age_group4' end age_group
조건 수식 이렇게 간단하게 해도 되나요 ?
