This is described in the accompanying text. In addition:

• a full scan is done of employees

• a full scan is done of departments

• a hash join is performed

• a GROUP BY SORT is performed

• the parallel execution coordinator is the final element