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
``` yaml
departments: # name of dataframe
- DEPARTMENT_ID:
    dtype: int64
    sample_values: 10, 20, 30
- DEPARTMENT_NAME:
    dtype: string
    sample_values: Administration, Marketing, Purchasing
- MANAGER_ID:
    dtype: int64
    sample_values: 200, 201, 114
- LOCATION_ID:
    dtype: int64
    sample_values: 1700, 1800, 1700

locations: # name of dataframe
- LOCATION_ID:
    dtype: int64
    sample_values: 1000, 1100, 1200
- STREET_ADDRESS:
    dtype: string
    sample_values: 1297 Via Cola di Rie, 93091 Calle della Testa, 2017 Shinjuku-ku
- POSTAL_CODE:
    dtype: numeric
    sample_values: 989, 10934, 1689
- CITY:
    dtype: string
    sample_values: Roma, Venice, Tokyo
- STATE_PROVINCE:
    dtype: string
    sample_values: ', , Tokyo Prefecture'
- COUNTRY_ID:
    dtype: string
    sample_values: IT, IT, JP

```
Foreign Key constraints:

DEPARTMENT_NAME,CITY,STATE_PROVINCE
Administration,Seattle,Washington
Marketing,Toronto,Ontario
Purchasing,Seattle,Washington
Human Resources,London,
Shipping,South San Francisco,California
IT,Southlake,Texas
Public Relations,Munich,Bavaria
Sales,OX9 9ZB,Oxford
Executive,Seattle,Washington
Finance,Seattle,Washington
Accounting,Seattle,Washington
Treasury,Seattle,Washington
Corporate Tax,Seattle,Washington
Control And Credit,Seattle,Washington
Shareholder Services,Seattle,Washington
Benefits,Seattle,Washington
Manufacturing,Seattle,Washington
Construction,Seattle,Washington
Contracting,Seattle,Washington
Operations,Seattle,Washington
IT Support,Seattle,Washington
NOC,Seattle,Washington
IT Helpdesk,Seattle,Washington
Government Sales,Seattle,Washington
Retail Sales,Seattle,Washington
Recruiting,Seattle,Washington
Payroll,Seattle,Washington
