display the first and last name, department, city, and state province 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
first name and last name refer to first_name, last_name in employees table; department refers to department_name in departments table; city and state province refer to city, state_province in locations table; joining of tables is required to relate employees to their departments and the location of these departments.