Show the names of employees with role name Editor.
select t1.employee_name from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t2.role_name = "Editor"
Show the names of roles with role code..
select role_code,role_name from roles
Show the id of employees with role Role_Code
select employee_id,role_code from employees
Show the Role_Code of roles with Role_Description.
select role_code,role_description from roles