Find me a customer with postal code 70174.
select * from customer where postalcode = 70174
Which employee was assigned to this customer? Give me the first and last names.
select t2.firstname, t2.lastname from customer as t1 join employee as t2 on t1.supportrepid = t2.employeeid where t1.postalcode = "70174"
Which city does he/she live?
select t2.city from customer as t1 join employee as t2 on t1.supportrepid = t2.employeeid where t1.postalcode = "70174"