select case when substr(cust_jumin, 7, 1) in ('1', '3')
then 'm'
else 'w'
end
from t_cust_inst
where prod_cd = '10000538'
select case when substr(cust_jumin, 7, 1) in ('1', '2')
then (year(today)) - (1900 + substr(cust_jumin, 1, 2)) + 1
else (year(today)) - (2000 + substr(cust_jumin, 1, 2)) + 1
end age,
case when substr(cust_jumin, 7, 1) in ('1', '3')
then '1'
else '2'
end sex
from t_cust_inst
where prod_cd = '10000538'