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
)