How many employees are there in the "Miami" office?
Miami office refers to locationcity = 'Miami'
SELECT COUNT(*) FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID WHERE T2.locationcity = 'Miami'