Looks like COUNT DISTINCT gives me a better result as it does not count NULLs