Hey Everyone,

Post your solutions ot the Nov. 7 In-Class Exercise to this thread.

Best,

Chris

SELECT maker, price, Printer.type

FROM Product, Printer

WHERE Product.model = Printer.model AND color = 'green';

SELECT maker

FROM Product, Laptop, PC

WHERE Product.model = Laptop.model AND Product.model = PC.model AND PC.price >= 1000;

1. Manufacturer, price, and type of green printers:

SELECT maker, price, Printer.type FROM Product, Printer WHERE Product.model = Printer.model AND color='green';

1. Manufacturer of laptops that do not sell PC's under $1,000:

(SELECT maker FROM Product, Laptop WHERE Product.model = Laptop.model)

EXCEPT

(SELECT maker FROM Product, PC WHERE Product.model = PC.model AND price < 1000);

SELECT maker, price, Printer.type FROM Product, Printer WHERE color = 'green' AND Printer.model = Product.model;

(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 Product.maker, Printer.price , Printer.type FROM Product,Printer WHERE Printer.color = 'green' AND Product.model = Printer.model;

2.(SELECT Product.maker FROM Product, Laptops WHERE Laptops.model = Product.model) EXCEPT (SELECT Product.maker FROM PC, Product WHERE PC.model = Product.model AND PC.price < 1000);

Student: Hongbin Zheng

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, 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, Printer.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);

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);

SELECT maker, price and 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);