How many employees are living in Hoffman Estates, IL?
in Hoffman Estates refers to city = 'Hoffman Estates'; IL refers to state = 'IL'
SELECT COUNT(employee_id) FROM employee WHERE state = 'IL' AND city = 'Hoffman Estates'