Show the name for all employees.
select employee_name from employees
Also show their role names.
select t1.employee_name, t2.role_name from employees as t1 join roles as t2 on t1.role_code = t2.role_code
Who has "Editor" as their role?
select t1.employee_name from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t2.role_name = "Editor"