Cacher is the code snippet organizer for pro developers

select
	[MajorVersion]
	, [Count] = COUNT(1)
from (
	select
		[svcVersion] = (
			CASE WHEN NOT [svcVersion] IS NULL THEN [svcVersion] ELSE [Version] END
		)
		, [MajorVersion] = SUBSTRING(CASE WHEN NOT [svcVersion] IS NULL THEN [svcVersion] ELSE [Version] END, 1, CHARINDEX('.', CASE WHEN NOT [svcVersion] IS NULL THEN [svcVersion] ELSE [Version] END) - 1)
		, [svcUpdateVersion]
		, [svcKBNumber]
	from Inv_USC_Internet_Explorer_Version
) [requery1]
group by [MajorVersion]
order by 2 desc