Skip to content

Latest commit

 

History

History
12 lines (9 loc) · 228 Bytes

ex5.md

File metadata and controls

12 lines (9 loc) · 228 Bytes

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')