Find all single CPU PCs with a processor speed of less than 1800

SELECT  Distinct
CS.Name0,
CPU.CurrentClockSpeed0,
CPU.MaxClockSpeed0
FROM  v_GS_COMPUTER_SYSTEM CS, v_GS_PROCESSOR CPU
WHERE CS.ResourceID = CPU.ResourceID
AND CPU.REsourceID not IN (select ResourceID from v_GS_PROCESSOR CPU group by ResourceID having count(CPU.ResourceID) > 1)
AND CPU.MaxClockSpeed0 < ‘1800’

Leave a Reply

Your email address will not be published. Required fields are marked *