Selecting distinct count when there's subsets of original populations + new entries

[sqlbrahzilla]

disregard.this post i figured it out.