Could you please display the first name and last name of each employee?
select first_name, last_name from employees
Could you add in their departments please?
select t1.first_name, t1.last_name, t2.department_name from employees as t1 join departments as t2 on t1.department_id = t2.department_id
Could you also list their cities and state provinces?
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