How many employees does each role have? List role description, id and number of employees.
select t1.role_description, t2.role_code, count(*) from roles as t1 join employees as t2 on t1.role_code = t2.role_code group by t2.role_code;