display the department name, city, and state province 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
[{'DEPARTMENT_NAME': 'Administration', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Marketing', 'CITY': 'Toronto', 'STATE_PROVINCE': 'Ontario'}, {'DEPARTMENT_NAME': 'Purchasing', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Human Resources', 'CITY': 'London', 'STATE_PROVINCE': ''}, {'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'DEPARTMENT_NAME': 'IT', 'CITY': 'Southlake', 'STATE_PROVINCE': 'Texas'}, {'DEPARTMENT_NAME': 'Public Relations', 'CITY': 'Munich', 'STATE_PROVINCE': 'Bavaria'}, {'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'DEPARTMENT_NAME': 'Executive', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Finance', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Accounting', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Treasury', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Corporate Tax', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Control And Credit', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Shareholder Services', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Benefits', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Manufacturing', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Construction', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Contracting', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Operations', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'IT Support', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'NOC', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'IT Helpdesk', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Government Sales', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Retail Sales', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Recruiting', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'DEPARTMENT_NAME': 'Payroll', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}]