Hello,

Here is another simple SQL way to find gaps in a numeric column,

that is: the lowest number for whom its successor (+1) does not exists... (regarding Jacob Sebastian's case):

SELECT min(t.CoordinatorID)...