select * from employees
select distinct name,age,case
when address like '%广州%' then '广州中山大'
when address like '%朝阳%' then '朝阳区'
end as addre
from employees
select * from employees
select distinct name,age,case
when address like '%广州%' then '广州中山大'
when address like '%朝阳%' then '朝阳区'
end as addre
from employees