SELECT T1.department_name ,  T2.city ,  T2.state_province FROM departments AS T1 JOIN locations AS T2 ON T2.location_id  =  T1.location_id
What are the department names, cities, and state provinces for each department?
SELECT T1.department_name , T2.city , T2.state_province FROM departments AS T1 JOIN locations AS T2 ON T2.location_id = T1.location_id
select t1 . department_name , t2 . city , t2 . state_province from departments as t1 join locations as t2 on t2 . location_id = t1 . location_id
What are the department names , cities , and state provinces for each department ?