What is the role of the employee named Koby?
create table roles (role_description varchar, role_code varchar, PRIMARY KEY (role_description)); create table employees (role_code varchar, employee_name varchar, PRIMARY KEY (role_code))
select t1.role_description from roles as t1 join employees as t2 on t1.role_code = t2.role_code where t2.employee_name = "koby"