q.select(c);
ParameterExpression<Division> param1 = cb.parameter(Division.class, "division");
sq.where(cb.equal(d.value().get(VicePresident_.id), 1));
q.where(cb.equal(param1, sq));
q.orderBy(cb.asc(c));
assertEquivalence(q, jpql, new String[]{"division"}, new Object[]{new Division()});
}