Exercise: 5

Find the model number, speed and hard drive capacity of PCs cheaper than $600 having a 12x or a 24x CD drive

Solution

SELECT model, speed, hd
FROM PC
WHERE price < 600
	AND cd IN ('12x', '24x')