Is this type of group by query possible in JPA ?

[Dave Mark]

Taking the query from this website as an example :

String query = "SELECT department.name, COUNT(employees) " +
"FROM Department department JOIN d.employees employees " +
"GROUP BY department.name"

is it possible to do something like this ?

String query = "SELECT department, employees " +
"FROM Department department RIGHT JOIN FETCH d.employees employees " +
"GROUP BY department";

Map<Department, List><Employee>> mapOfLists = em.createQuery(query).getResultList();

I've shortened it down everything to a minimum while still showing the result I'm looking for (and yes I know it doesn't work!).

What I have at the moment is something like the following...

String query = "SELECT employee " +
"FROM Employee employee LEFT JOIN FETCH employee.department department " +
"ORDER BY department";

List<Employee> employees = em.createQuery(query).getResultList();
Map<Department, List><Employee>> mapOfLists = sortListIntoMap(employees);

So is there anyway of getting closer to what I'm after?
Will a projection help me?
Or will I always have to iterate over the result to sort it?