how many employees are there?
select count ( * ) from employees
show their names please.
select employee_name from employees
what is the date of birth of the employee named Ebba?
select date_of_birth from employees where employee_name = "Ebba"
ok, what are her role name and description?
select t2.role_name, t2.role_description from employees as t1 join roles as t2 on t1.role_code = t2.role_code where t1.employee_name = "Ebba"