How about for all employees with the role name "Human Resource"?
select t1.employee_id from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t2.role_name = "Human Resource"
What is that employee's name?
select t1.employee_name from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t2.role_name = "Human Resource"
What is the name of the employee whose role name is Manager?
select t1.employee_name from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t2.role_name = "Manager"
What is the name of the employee whose role name is Human Resources?
select t1.employee_name from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t2.role_name = "Human Resource"