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
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
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
display the first and last name , department , city , and state province for each employee .