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’