getEmployeeWithProject

private void getEmployeeWithProject() {
        Scanner scanner = new Scanner(System.in);
        int em_id = Integer.parseInt(scanner.nextLine());

        Employee employee = this.entityManager.createQuery("FROM Employee WHERE id = :em_id", Employee.class)
                .setParameter("em_id", em_id).getSingleResult();

        System.out.printf("%s %s - %s", employee.getFirstName(), employee.getLastName(), employee.getJobTitle()).println();

        List names = this.entityManager.createNativeQuery("select p.name from projects p\n" +
                "join employees_projects ep\n" +
                "on p.project_id = ep.project_id\n" +
                "where ep.employee_id = ?\n" +
                "order by p.name;")
                .setParameter(1, em_id)
                .getResultList();

        names.forEach(e -> System.out.printf("      %s", e).println());

    }