SQL Query To Count Microsoft Office Versions From Add And Remove Programs

SQL :

Select

Count(ResourceID) Counts,

DisplayName0,

Publisher0,

Version0

From v_Add_Remove_Programs

Where Publisher0 = 'Microsoft Corporation'

And DisplayName0 Like 'Microsoft Office%'

Group By DisplayName0, Publisher0, version0

Order By Counts Desc