display the first and last name, department, city, and state province for each employee.
SELECT T1.first_name ,  T1.last_name ,  T2.department_name ,  T3.city ,  T3.state_province FROM employees AS T1 JOIN departments AS T2 ON T1.department_id  =  T2.department_id JOIN locations AS T3 ON T2.location_id  =  T3.location_id
SELECT T1.first_name ,  T1.last_name ,  T2.department_name ,  T3.city ,  T3.state_province FROM employees AS T1 JOIN departments AS T2 ON T1.department_id  =  T2.department_id JOIN locations AS T3 ON T2.location_id  =  T3.location_id
[{'FIRST_NAME': 'Steven', 'LAST_NAME': 'King', 'DEPARTMENT_NAME': 'Executive', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Neena', 'LAST_NAME': 'Kochhar', 'DEPARTMENT_NAME': 'Executive', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Lex', 'LAST_NAME': 'De Haan', 'DEPARTMENT_NAME': 'Executive', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Alexander', 'LAST_NAME': 'Hunold', 'DEPARTMENT_NAME': 'IT', 'CITY': 'Southlake', 'STATE_PROVINCE': 'Texas'}, {'FIRST_NAME': 'Bruce', 'LAST_NAME': 'Ernst', 'DEPARTMENT_NAME': 'IT', 'CITY': 'Southlake', 'STATE_PROVINCE': 'Texas'}, {'FIRST_NAME': 'David', 'LAST_NAME': 'Austin', 'DEPARTMENT_NAME': 'IT', 'CITY': 'Southlake', 'STATE_PROVINCE': 'Texas'}, {'FIRST_NAME': 'Valli', 'LAST_NAME': 'Pataballa', 'DEPARTMENT_NAME': 'IT', 'CITY': 'Southlake', 'STATE_PROVINCE': 'Texas'}, {'FIRST_NAME': 'Diana', 'LAST_NAME': 'Lorentz', 'DEPARTMENT_NAME': 'IT', 'CITY': 'Southlake', 'STATE_PROVINCE': 'Texas'}, {'FIRST_NAME': 'Nancy', 'LAST_NAME': 'Greenberg', 'DEPARTMENT_NAME': 'Finance', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Daniel', 'LAST_NAME': 'Faviet', 'DEPARTMENT_NAME': 'Finance', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'John', 'LAST_NAME': 'Chen', 'DEPARTMENT_NAME': 'Finance', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Ismael', 'LAST_NAME': 'Sciarra', 'DEPARTMENT_NAME': 'Finance', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Jose Manuel', 'LAST_NAME': 'Urman', 'DEPARTMENT_NAME': 'Finance', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Luis', 'LAST_NAME': 'Popp', 'DEPARTMENT_NAME': 'Finance', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Den', 'LAST_NAME': 'Raphaely', 'DEPARTMENT_NAME': 'Purchasing', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Alexander', 'LAST_NAME': 'Khoo', 'DEPARTMENT_NAME': 'Purchasing', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Shelli', 'LAST_NAME': 'Baida', 'DEPARTMENT_NAME': 'Purchasing', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Sigal', 'LAST_NAME': 'Tobias', 'DEPARTMENT_NAME': 'Purchasing', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Guy', 'LAST_NAME': 'Himuro', 'DEPARTMENT_NAME': 'Purchasing', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Karen', 'LAST_NAME': 'Colmenares', 'DEPARTMENT_NAME': 'Purchasing', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Matthew', 'LAST_NAME': 'Weiss', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Adam', 'LAST_NAME': 'Fripp', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Payam', 'LAST_NAME': 'Kaufling', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Shanta', 'LAST_NAME': 'Vollman', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Kevin', 'LAST_NAME': 'Mourgos', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Julia', 'LAST_NAME': 'Nayer', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Irene', 'LAST_NAME': 'Mikkilineni', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'James', 'LAST_NAME': 'Landry', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Steven', 'LAST_NAME': 'Markle', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Laura', 'LAST_NAME': 'Bissot', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Mozhe', 'LAST_NAME': 'Atkinson', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'James', 'LAST_NAME': 'Marlow', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'TJ', 'LAST_NAME': 'Olson', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Jason', 'LAST_NAME': 'Mallin', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Michael', 'LAST_NAME': 'Rogers', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Ki', 'LAST_NAME': 'Gee', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Hazel', 'LAST_NAME': 'Philtanker', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Renske', 'LAST_NAME': 'Ladwig', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Stephen', 'LAST_NAME': 'Stiles', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'John', 'LAST_NAME': 'Seo', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Joshua', 'LAST_NAME': 'Patel', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Trenna', 'LAST_NAME': 'Rajs', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Curtis', 'LAST_NAME': 'Davies', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Randall', 'LAST_NAME': 'Matos', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Peter', 'LAST_NAME': 'Vargas', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'John', 'LAST_NAME': 'Russell', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Karen', 'LAST_NAME': 'Partners', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Alberto', 'LAST_NAME': 'Errazuriz', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Gerald', 'LAST_NAME': 'Cambrault', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Eleni', 'LAST_NAME': 'Zlotkey', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Peter', 'LAST_NAME': 'Tucker', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'David', 'LAST_NAME': 'Bernstein', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Peter', 'LAST_NAME': 'Hall', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Christopher', 'LAST_NAME': 'Olsen', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Nanette', 'LAST_NAME': 'Cambrault', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Oliver', 'LAST_NAME': 'Tuvault', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Janette', 'LAST_NAME': 'King', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Patrick', 'LAST_NAME': 'Sully', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Allan', 'LAST_NAME': 'McEwen', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Lindsey', 'LAST_NAME': 'Smith', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Louise', 'LAST_NAME': 'Doran', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Sarath', 'LAST_NAME': 'Sewall', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Clara', 'LAST_NAME': 'Vishney', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Danielle', 'LAST_NAME': 'Greene', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Mattea', 'LAST_NAME': 'Marvins', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'David', 'LAST_NAME': 'Lee', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Sundar', 'LAST_NAME': 'Ande', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Amit', 'LAST_NAME': 'Banda', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Lisa', 'LAST_NAME': 'Ozer', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Harrison', 'LAST_NAME': 'Bloom', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Tayler', 'LAST_NAME': 'Fox', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'William', 'LAST_NAME': 'Smith', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Elizabeth', 'LAST_NAME': 'Bates', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Sundita', 'LAST_NAME': 'Kumar', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Ellen', 'LAST_NAME': 'Abel', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Alyssa', 'LAST_NAME': 'Hutton', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Jonathon', 'LAST_NAME': 'Taylor', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Jack', 'LAST_NAME': 'Livingston', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Charles', 'LAST_NAME': 'Johnson', 'DEPARTMENT_NAME': 'Sales', 'CITY': 'OX9 9ZB', 'STATE_PROVINCE': 'Oxford'}, {'FIRST_NAME': 'Winston', 'LAST_NAME': 'Taylor', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Jean', 'LAST_NAME': 'Fleaur', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Martha', 'LAST_NAME': 'Sullivan', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Girard', 'LAST_NAME': 'Geoni', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Nandita', 'LAST_NAME': 'Sarchand', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Alexis', 'LAST_NAME': 'Bull', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Julia', 'LAST_NAME': 'Dellinger', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Anthony', 'LAST_NAME': 'Cabrio', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Kelly', 'LAST_NAME': 'Chung', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Jennifer', 'LAST_NAME': 'Dilly', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Timothy', 'LAST_NAME': 'Gates', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Randall', 'LAST_NAME': 'Perkins', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Sarah', 'LAST_NAME': 'Bell', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Britney', 'LAST_NAME': 'Everett', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Samuel', 'LAST_NAME': 'McCain', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Vance', 'LAST_NAME': 'Jones', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Alana', 'LAST_NAME': 'Walsh', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Kevin', 'LAST_NAME': 'Feeney', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Donald', 'LAST_NAME': 'OConnell', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Douglas', 'LAST_NAME': 'Grant', 'DEPARTMENT_NAME': 'Shipping', 'CITY': 'South San Francisco', 'STATE_PROVINCE': 'California'}, {'FIRST_NAME': 'Jennifer', 'LAST_NAME': 'Whalen', 'DEPARTMENT_NAME': 'Administration', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'Michael', 'LAST_NAME': 'Hartstein', 'DEPARTMENT_NAME': 'Marketing', 'CITY': 'Toronto', 'STATE_PROVINCE': 'Ontario'}, {'FIRST_NAME': 'Pat', 'LAST_NAME': 'Fay', 'DEPARTMENT_NAME': 'Marketing', 'CITY': 'Toronto', 'STATE_PROVINCE': 'Ontario'}, {'FIRST_NAME': 'Susan', 'LAST_NAME': 'Mavris', 'DEPARTMENT_NAME': 'Human Resources', 'CITY': 'London', 'STATE_PROVINCE': ''}, {'FIRST_NAME': 'Hermann', 'LAST_NAME': 'Baer', 'DEPARTMENT_NAME': 'Public Relations', 'CITY': 'Munich', 'STATE_PROVINCE': 'Bavaria'}, {'FIRST_NAME': 'Shelley', 'LAST_NAME': 'Higgins', 'DEPARTMENT_NAME': 'Accounting', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}, {'FIRST_NAME': 'William', 'LAST_NAME': 'Gietz', 'DEPARTMENT_NAME': 'Accounting', 'CITY': 'Seattle', 'STATE_PROVINCE': 'Washington'}]