select
  e.last_name,
  d.department_name
from employees e,
  departments d
where e.DEPARTMENT_ID=d.department_id and instr(e.last_name,'a')>0