What are the names of each department?
select department_name from departments
Also, in what city and state province are they in?
select t1.department_name, t2.city, t2.state_province from departments as t1 join locations as t2 on t2.location_id = t1.location_id