Yioop - PHP Search Engine

-- Nov 6 In-Class Exercise Thread

1) SELECT Product.Maker AS Manufacturer, laptop.price, laptop.model FROM Product, Laptop WHERE Product.model = Laptop.model AND Laptop.ram > 16

2) SELECT Product.maker AS manufacturer FROM Product, PC WHERE product.type = printer AND product.model=pc.model EXCEPT SELECT Product.maker as manufacturer WHERE product.type = pc AND PC.price > 800

1) SELECT Product.Maker AS Manufacturer, laptop.price, laptop.model FROM Product, Laptop WHERE Product.model = Laptop.model AND Laptop.ram > 16 2) SELECT Product.maker AS manufacturer FROM Product, PC WHERE product.type = printer AND product.model=pc.model EXCEPT SELECT Product.maker as manufacturer WHERE product.type = pc AND PC.price > 800

-- Nov 6 In-Class Exercise Thread

1)

(SELECT maker, model FROM Product WHERE type = ‘Laptop’)

	INTERSECT

(SELECT model, price FROM Laptop WHERE ram > 16);

2)

SELECT maker as manufacturer FROM Product, PC, Printer WHERE Product.model = PC.model AND PC.model = Printer.model, PC.price >= $800 (Edited: 2019-11-13)

1) (SELECT maker, model FROM Product WHERE type = ‘Laptop’) INTERSECT (SELECT model, price FROM Laptop WHERE ram > 16); 2) SELECT maker as manufacturer FROM Product, PC, Printer WHERE Product.model = PC.model AND PC.model = Printer.model, PC.price >= $800

-- Nov 6 In-Class Exercise Thread

1. SELECT price, model, maker AS manufacturer

FROM Product, Laptop

WHERE ram > 16 AND type = 'laptop' AND Laptop.model = Product.model

2. SELECT maker AS manufacturer

FROM (Printer NATURAL JOIN Product) NATURAL JOIN (PC NATURAL JOIN Product)

WHERE PC.price >= 800

1. SELECT price, model, maker AS manufacturer FROM Product, Laptop WHERE ram > 16 AND type = 'laptop' AND Laptop.model = Product.model 2. SELECT maker AS manufacturer FROM (Printer NATURAL JOIN Product) NATURAL JOIN (PC NATURAL JOIN Product) WHERE PC.price >= 800

-- Nov 6 In-Class Exercise Thread

1- SELECT Product.maker AS manufacturer, Laptop.price, Laptop.model

   FROM Product,Laptop
   WHERE Product.model = Laptop.model AND Laptop.ram > 16;

 2- (SELECT maker as manufacturer
   FROM Product, Printer
   WHERE Product.model = Printer.model AND Product.type = 'Printer')
   EXCEPT
   (SELECT maker as manufacturer
   WHERE Product.type = 'PC' AND Product.model = PC.model AND PC.price < 800);

1- SELECT Product.maker AS manufacturer, Laptop.price, Laptop.model FROM Product,Laptop WHERE Product.model = Laptop.model AND Laptop.ram > 16; 2- (SELECT maker as manufacturer FROM Product, Printer WHERE Product.model = Printer.model AND Product.type = 'Printer') EXCEPT (SELECT maker as manufacturer WHERE Product.type = 'PC' AND Product.model = PC.model AND PC.price < 800);

-- Nov 6 In-Class Exercise Thread

1) SELECT Product.maker AS manufacturer, Laptop.price, Laptop.model FROM Product,Laptop WHERE Product.model = Laptop.model AND Laptop.ram > 16;

2) (SELECT Product.maker AS manufacturer FROM Product WHERE Product.model = Printer.model AND Product.type = 'Printer') EXCEPT (SELECT Product.maker AS manufacturer FROM Product WHERE Product.model = PC.model AND Product.type = 'PC' AND PC.price < 800);

1) SELECT Product.maker AS manufacturer, Laptop.price, Laptop.model FROM Product,Laptop WHERE Product.model = Laptop.model AND Laptop.ram > 16; 2) (SELECT Product.maker AS manufacturer FROM Product WHERE Product.model = Printer.model AND Product.type = 'Printer') EXCEPT (SELECT Product.maker AS manufacturer FROM Product WHERE Product.model = PC.model AND Product.type = 'PC' AND PC.price < 800);

-- Nov 6 In-Class Exercise Thread

1. SELECT maker as manufacturer, price, model

FROM Laptop, Product

WHERE Product.type = 'laptop' AND Product.model = Laptop.Model AND Laptop.ram>16

2. SELECT maker as manufacturer FROM Printer, Product

WHERE Product.model = Printer.model AND Product.type = 'printer'

EXCEPT

(SELECT maker as manufacture

FROM Product, PC

WHERE Product.model = PC.model AND PC.price <800)

1. SELECT maker as manufacturer, price, model FROM Laptop, Product WHERE Product.type = 'laptop' AND Product.model = Laptop.Model AND Laptop.ram>16 2. SELECT maker as manufacturer FROM Printer, Product WHERE Product.model = Printer.model AND Product.type = 'printer' EXCEPT (SELECT maker as manufacture FROM Product, PC WHERE Product.model = PC.model AND PC.price <800)

-- Nov 6 In-Class Exercise Thread

SELECT Product.maker, Laptop.price, Laptop.model FROM Laptop, Product WHERE Laptop.ram > 16Gb AND Product.model = Laptop.model;

SELECT Product.maker FROM Product, PC WHERE PC.price < 800 and Product.model = PC.model

SELECT Product.maker, Laptop.price, Laptop.model FROM Laptop, Product WHERE Laptop.ram > 16Gb AND Product.model = Laptop.model; SELECT Product.maker FROM Product, PC WHERE PC.price < 800 and Product.model = PC.model

-- Nov 6 In-Class Exercise Thread

1) (SELECT maker as manufacturer, Laptop.price, Laptop.model FROM product, laptop

 WHERE ram > 16 AND laptop.model = product.model)
 
 2) (SELECT maker as manufacturer FROM product, printer WHERE product.model = printer.model) 
 EXCEPT
 (SELECT maker as manufacturer WHERE product.model = pc.model AND pc.price < 800)

1) (SELECT maker as manufacturer, Laptop.price, Laptop.model FROM product, laptop WHERE ram > 16 AND laptop.model = product.model) 2) (SELECT maker as manufacturer FROM product, printer WHERE product.model = printer.model) EXCEPT (SELECT maker as manufacturer WHERE product.model = pc.model AND pc.price < 800)

-- Nov 6 In-Class Exercise Thread

1) SELECT Product.maker AS manufacturer, laptop.price, laptop.model FROM Product, laptop WHERE Product.model = Laptop.model AND Laptop.ram > 16

2) SELECT Product.maker AS manufacturer FROM product, PC WHERE Product.type = printer AND Product.model= PC.model EXCEPT SELECT Product.maker as manufacturer WHERE product.type = PC AND PC.price > 800

1) SELECT Product.maker AS manufacturer, laptop.price, laptop.model FROM Product, laptop WHERE Product.model = Laptop.model AND Laptop.ram > 16 2) SELECT Product.maker AS manufacturer FROM product, PC WHERE Product.type = printer AND Product.model= PC.model EXCEPT SELECT Product.maker as manufacturer WHERE product.type = PC AND PC.price > 800

-- Nov 6 In-Class Exercise Thread

 1) SELECT maker as manufacturer, Laptop.price, Laptop.model 
 FROM product, laptop
 WHERE ram > 16 AND laptop.model = product.model AND type = 'laptop';
 
 2) SELECT maker as manufacturer
 FROM product, printer
 WHERE product.model = printer.model AND product.type = 'printer'
 EXCEPT
 SELECT maker as manufacturer
 WHERE product.type = 'pc' AND product.model = pc.model AND pc.price < 800;

1) SELECT maker as manufacturer, Laptop.price, Laptop.model FROM product, laptop WHERE ram > 16 AND laptop.model = product.model AND type = 'laptop'; 2) SELECT maker as manufacturer FROM product, printer WHERE product.model = printer.model AND product.type = 'printer' EXCEPT SELECT maker as manufacturer WHERE product.type = 'pc' AND product.model = pc.model AND pc.price < 800;