text: column ename format a20
  column rname format a20
  
  select /*+ gather_plan_statistics */
         e.ename,r.rname
  from   employees  e
  join   roles       r on (r.id = e.role_id)
  join   departments d on (d.id = e.dept_id)
  where  e.staffno <= 10
  and    d.dname in ('Department Name 1','Department Name 2');
  
  @stats
  