
CREATE VIEW ComboMaker(maker, pcModel, laptopModel) AS
  SELECT maker, P1.model, P2.model
  FROM Product AS P1
         INNER JOIN
       Product AS P2
       USING (maker)
  WHERE P1.type = 'pc'
    AND P2.type = 'laptop';