How many employees have the 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"
Can you list their names in this chat box?
select t1.employee_name from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t2.role_name = "Editor"
How many have a DOB after 1978?
select count ( * ) from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t2.role_name = "Editor" and t1.date_of_birth > 1978