DELETE FROM employees
    WHERE department_id =
        (SELECT department_id
        FROM departments
        WHERE department_name LIKE ‘%Public%’);