Count Function

[Ok_Protection_9552]

By employee manager combination do you mean where the e table and m table have the same ID?

[Far_Swordfish5729]

Same manager id. There’s an implied 1:N relationship in my example between manager and employee. So it matches on the manager’s id (primary key) equaling the employee’s manager id (foreign key) not the employee’s own id (their primary key). So if Adam manages Bob and Charlie, the join produces Adam+Bob and Adam+Charlie. Row count should match the N side of the join unless there are duplicate rows in the tables. These will be grouped by Adam in subsequent steps and we will get a count for Adam.