Yioop - PHP Search Engine

Nov 7 In-Class Exercise.

Hey Everyone,

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

Best,

Chris

Hey Everyone, Post your solutions ot the Nov. 7 In-Class Exercise to this thread. Best, Chris

-- Nov 7 In-Class Exercise

1)

SELECT maker, price, Printer.type

FROM Product, Printer

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

2)

SELECT maker

FROM Product, Laptop, PC

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

(Edited: 2018-11-07)

1) SELECT maker, price, Printer.type FROM Product, Printer WHERE Product.model = Printer.model AND color = 'green'; 2) SELECT maker FROM Product, Laptop, PC WHERE Product.model = Laptop.model AND Product.model = PC.model AND PC.price >= 1000;

-- Nov 7 In-Class Exercise

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

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

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

(Edited: 2018-11-07)

1. Manufacturer, price, and type of green printers: SELECT maker, price, Printer.type FROM Product, Printer WHERE Product.model = Printer.model AND color='green'; 2. 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);

-- Nov 7 In-Class Exercise

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)

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

-- Nov 7 In-Class Exercise

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

(Edited: 2018-11-07)

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

-- Nov 7 In-Class Exercise

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

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

-- Nov 7 In-Class Exercise

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

(Edited: 2018-11-07)

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

-- Nov 7 In-Class Exercise

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

(Edited: 2018-11-07)

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

-- Nov 7 In-Class Exercise

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

(Edited: 2018-11-07)

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

-- Nov 7 In-Class Exercise

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