SQL: Internet Explorer Major Version Counts
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