What are the full names, departments, cities, and state provinces for each employee?
SELECT T1.first_name ,  T1.last_name ,  T2.department_name ,  T3.city ,  T3.state_province FROM employees AS T1 JOIN departments AS T2 ON T1.department_id  =  T2.department_id JOIN locations AS T3 ON T2.location_id  =  T3.location_id
full names refer to first_name and last_name; departments refer to department_name; cities refer to city; state provinces refer to state_province; each employee refers to joining employees with departments and locations based on department_id and location_id respectively;