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