select city
from zipcodes z, employees e, customers c
where z.zip = e.zip and 
      e.ename = c.cname and 
      c.zip = z.zip and c.cno in (select o.cno from
                                  orders o
                                  where o.cno = c.cno); 


