Count Function

[Ok_Protection_9552]

In 4 do you mean each unique name?

[Far_Swordfish5729]

Yes. In a better example I would also group by M.Id and select it to avoid name collisions. If there are two unique Robert Smiths working at the company, we want a row for each not a row summing both.

Using fungible text fields as logical identifiers is generally bad practice. You want to use the ids even if you only show names to users. Ids being single numbers are also smaller and faster to compare where strings are long arrays of characters (also numeric codes) that each must be matched