2018-11-19
1.SELECT maker, price, Printer.type FROM Product, Printer WHERE Product.model = Printer.model AND color = 'green'; 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);
1.
SELECT maker, price, Printer.type
FROM Product, Printer
WHERE Product.model = Printer.model AND color = 'green';
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);
The manufacturer, price, and type of printers which come in green.
SELECT maker, price, type
FROM Product, Printer
WHERE Printer.color = 'green' AND Product.model = Printer.model;
The manufacturers of laptops that do not sell PCs under $1000.
(SELECT maker
FROM Product, Laptop
WHERE Product.model = Laptop.model)
EXCEPT
(SELECT maker
FROM Product, PC
WHERE Product.model = PC.model, PC.price <1000;)
The manufacturer, price, and type of printers which come in green.
SELECT maker, price, type
FROM Product, Printer
WHERE Printer.color = 'green' AND Product.model = Printer.model;
The manufacturers of laptops that do not sell PCs under $1000.
(SELECT maker
FROM Product, Laptop
WHERE Product.model = Laptop.model)
EXCEPT
(SELECT maker
FROM Product, PC
WHERE Product.model = PC.model, PC.price <1000;)
(c) 2024 Yioop - PHP Search Engine