Select Top 1000000 tblSoftware.softwareVersion As Version,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like '%microsoft office%365%') Or
  (tblSoftwareUni.softwareName Like '%microsoft 365%' And tblAssetCustom.State =
    1 And tblAssets.Assettype = -1)
Group By tblSoftware.softwareVersion,
  tblSoftwareUni.softwareName
Order By Version,
  Total Desc