CREATE TABLE employees (employee_id NUMBER, role_code CLOB, employee_name CLOB, gender_mfu CLOB, date_of_birth TIME, other_details CLOB)
CREATE TABLE ref_locations (location_code CLOB, location_name CLOB, location_description CLOB)
CREATE TABLE documents_to_be_destroyed (document_id NUMBER, destruction_authorised_by_employee_id NUMBER, destroyed_by_employee_id NUMBER, planned_destruction_date TIME, actual_destruction_date TIME, other_details CLOB)
CREATE TABLE all_documents (document_id NUMBER, date_stored TIME, document_type_code CLOB, document_name CLOB, document_description CLOB, other_details CLOB)
CREATE TABLE ref_document_types (document_type_code CLOB, document_type_name CLOB, document_type_description CLOB)
CREATE TABLE roles (role_code CLOB, role_name CLOB, role_description CLOB)
CREATE TABLE ref_calendar (calendar_date TIME, day_number NUMBER)
CREATE TABLE document_locations (document_id NUMBER, location_code CLOB, date_in_location_from TIME, date_in_locaton_to TIME)

What is the role name and role description for employee called Ebba?
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"
SELECT "T2"."role_name", "T2"."role_description" FROM "employees" "T1" JOIN "roles" "T2" ON "T1"."role_code" = "T2"."role_code" WHERE "Ebba" = "T1"."employee_name"