select REG.Status0 as ‘Status’, Count(REG.Status0) as ‘Count’
from dbo.v_GS_REGISTRY REG
Group by REG.Status0