
-- We can solve the exercise with a query against a single relation:

SELECT model, price
FROM Laptop
WHERE price < 1000  AND
      model IN (SELECT laptopModel
                FROM ComboMaker);

-- We can also query against a join, which also gives us access
-- to ComboMaker's attributes for output:

SELECT DISTINCT model, price, maker
FROM Laptop, ComboMaker
WHERE Laptop.price < 1000  AND
      Laptop.model = ComboMaker.laptopModel;
