Select
Case 
when SubQuery3.Value like 'cimighlppcgcoapaliogpjjdehbnofhn%' and SubQuery3.Value not like 'odfafepnkmbhccpbejgmiehpchacaeak%' and SubQuery4.Value = 'odfafepnkmbhccpbejgmiehpchacaeak'
and SubQuery2.Valuename = 'disableFirstRunPage' and SubQuery2.Value = '1' 
Then 'Yes' else 'No'
end as [Setup Complete],
Count(distinct tblassets.Assetid) as Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Inner Join tblComputerSystem On tblComputerSystem.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
tblRegistry.Regkey Like '%SOFTWARE\Policies\Microsoft\Edge\3rdparty\Extensions\cimighlppcgcoapaliogpjjdehbnofhn\policy' and tblRegistry.Valuename = 'disableFirstRunPage') as SubQuery2
On SubQuery2.AssetID = tblAssets.AssetID

Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
(tblRegistry.Regkey Like '%SOFTWARE\Policies\Microsoft\Edge\ExtensionInstallForcelist' And
(tblRegistry.Value like 'cimighlppcgcoapaliogpjjdehbnofhn%' Or
tblRegistry.Value like 'odfafepnkmbhccpbejgmiehpchacaeak%'))
) as SubQuery3
On SubQuery3.AssetID = tblAssets.AssetID

Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
(tblRegistry.Regkey Like '%SOFTWARE\Policies\Microsoft\Edge\ExtensionInstallBlocklist' And
(tblRegistry.Value = 'odfafepnkmbhccpbejgmiehpchacaeak'))
) as SubQuery4
On SubQuery4.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And TsysWaittime.CFGname = 'registry' and tblComputersystem.Domainrole <= 1
Group by SubQuery3.Value, SubQuery4.Value, SubQuery2.Valuename, SubQuery2.Value