SELECT maker, price, Printer.type FROM Product, Printer WHERE Product.model = Printer.model AND color='green';
(SELECT maker FROM Product, Laptop WHERE Product.model = Laptop.model)
EXCEPT
(SELECT maker FROM Product, PC WHERE Product.model = PC.model AND price < 1000);
1.
SELECT maker, price, Printer.type FROM Product, Printer WHERE color = 'green' AND Printer.model = Product.model;
2. (SELECT maker FROM Product, Laptop WHERE Product.model = Laptop.model) EXCEPT (SELECT maker FROM Product, PC WHERE Product.model = PC.model AND price < 1000);(Edited: 2018-11-07)
EXCEPT (SELECT Product.maker FROM PC, Product WHERE PC.model = Product.model AND PC.price < 1000);
1.(SELECT maker, price, type FROM Product, Printer WHERE Product.model = Printer.model INTERSECT color = 'green');
2.(SELECT maker FROM Product, Laptop WHERE Product.model = Laptop.model)
EXCEPT
(SELECT maker FROM Product, PC WHERE Product.model = PC.model INTERSECT price < 1000);
SELECT maker, Printer.price, Printer.type
FROM Product, Printer
WHERE Product.model = Printer.model AND color = 'green';
(SELECT maker
FROM Product, Laptop WHERE Product.model = Laptop.model)
EXCEPT
(SELECT maker
FROM Product, PC
WHERE Product.model = PC>model AND price < 1000);