Exercise: 17

Get the laptop models that have a speed smaller than the speed of any PC.

Result set: type, model, speed.

Solution

SELECT DISTINCT product.type, product.model, laptop.speed
FROM laptop
	JOIN product ON laptop.model = product.model
WHERE speed < (
	SELECT MIN(speed)
	FROM pc
)