# entity result: findByDepartmentName("Sales")
select e1_0.id,e1_0.bio,e1_0.department_id,e1_0.email,e1_0.first_name,e1_0.last_name,e1_0.salary from employee e1_0 left join department d1_0 on d1_0.id=e1_0.department_id where d1_0.name=?
columns selected: 7, entities now managed by the persistence context: 4

# closed interface projection: findSummaryByDepartmentName("Sales")
select e1_0.first_name,e1_0.last_name from employee e1_0 left join department d1_0 on d1_0.id=e1_0.department_id where d1_0.name=?
columns selected: 2, entities now managed by the persistence context: 0

# record DTO projection: findDtoByDepartmentName("Sales")
select e1_0.first_name,e1_0.last_name from employee e1_0 left join department d1_0 on d1_0.id=e1_0.department_id where d1_0.name=?
columns selected: 2, entities now managed by the persistence context: 0