In which city's office does Sandy Adams work at?
Sandy Adams is the fullname of an employee; full name = firstname, lastname; city refers to locationcity
SELECT T2.locationcity FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID WHERE T1.lastname = 'Adams' AND T1.firstname = 'Sandy'