问如何在case语句中添加子查询查询

EN

select distinct 
    a.id, a.number, b.number as school_number, b.id as school_id 
from
    (select distinct a.id, a.number 
     from faculty a 
     where a.status = 'active') as t1
full outer join
    (select distinct b.id, b.number 
     from staff b 
     where b.status = 'active') as t2 on t1.id = t2.id

create view v_data 
as
    (select 
         name_loc,
         case 
             when name_loc like '%city%' or
             when name_loc like '%cities%'  
                 then 'Survey'