CREATE TABLE locations (city VARCHAR(255), state_province VARCHAR(255), location_id VARCHAR(255)); CREATE TABLE departments (department_name VARCHAR(255), location_id VARCHAR(255))
display the department name, city, and state province for each department.
    
SQL: SELECT T1.department_name, T2.city, T2.state_province FROM departments AS T1 JOIN locations AS T2 ON T2.location_id = T1.location_id