Yioop - PHP Search Engine

-- Nov 6 In-Class Exercise Thread

 1.The manufacturer, price, and model of laptops which have more than 16GB of ram.
 
  SELECT Product.maker, Laptop.price, Laptop.model
  FROM Product, Laptop
  WHERE Product.model = Laptop.model AND Laptop.ram > 16
 
 2. The manufacturers of printers that do not sell PCs under $800.

  ( SELECT Product.maker
  FROM Product, Printer
  WHERE Product.model = Printer.model )
  EXCEPT
  ( SELECT Product.maker
  FROM Product, PC
  WHERE Product.model = PC.model AND PC.price < 800)

(Edited: 2019-11-06)

1.The manufacturer, price, and model of laptops which have more than 16GB of ram. SELECT Product.maker, Laptop.price, Laptop.model FROM Product, Laptop WHERE Product.model = Laptop.model AND Laptop.ram > 16 2. The manufacturers of printers that do not sell PCs under $800. ( SELECT Product.maker FROM Product, Printer WHERE Product.model = Printer.model ) EXCEPT ( SELECT Product.maker 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 Product, Laptop

WHERE ram > 16 AND Laptop.model = Product.model AND type=‘Laptop’

SELECT maker

FROM PC, Printer

 WHERE Product.model = Printer.model AND Product.type=‘Printer’

EXCEPT

SELECT maker

FROM Product, Pc

WHERE Pc.price < 800 AND Product.type=‘Pc’ AND Product.model=Pc.model

(Edited: 2019-11-06)

SELECT Product.maker, Laptop.price, Laptop.model FROM Product, Laptop WHERE ram > 16 AND Laptop.model = Product.model AND type=‘Laptop’ SELECT maker FROM PC, Printer  WHERE Product.model = Printer.model AND Product.type=‘Printer’ EXCEPT SELECT maker FROM Product, Pc WHERE Pc.price < 800 AND Product.type=‘Pc’ AND Product.model=Pc.model

-- Nov 6 In-Class Exercise Thread

1. select Product.maker, Laptop.price, Laptop.model from Product, Laptop where Product.model = Laptop.model and ram > 16;

2. (select Product.maker from Product, Printer where Printer.model = Product.model ) except (select Product.maker From Product, PC where Product.model = PC.model and PC.price < 800)

(Edited: 2019-11-06)

1. select Product.maker, Laptop.price, Laptop.model from Product, Laptop where Product.model = Laptop.model and ram > 16; 2. (select Product.maker from Product, Printer where Printer.model = Product.model ) except (select Product.maker From Product, PC where Product.model = PC.model 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)
 
 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 maker as Manufacturer, Laptop.price, Laptop.model

From product, laptop

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

2. The manufacturers of printers that do not sell PCs under $800.

SELECT maker as manufacturer

FROM Product, PC, Printer

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

(Edited: 2019-11-06)

1. SELECT maker as Manufacturer, Laptop.price, Laptop.model From product, laptop WHERE Laptop.ram >16 AND laptop.model = product.model AND type = 'laptop'; 2. The manufacturers of printers that do not sell PCs under $800. SELECT maker as manufacturer FROM Product, PC, Printer WHERE 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 Laptop.ram AND Laptop.price, Product.maker as manufacturer AND Product.model

FROM Laptop, Product

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

2. SELECT Product.maker as manufacturer

FROM Product, PC, Printer

WHERE Product.model = PC.model AND PC.model = Printer.model, PC.price >= $800

1. SELECT Laptop.ram AND Laptop.price, Product.maker as manufacturer AND Product.model FROM Laptop, Product WHERE Laptop.ram > 16GB AND Laptop.model = Product.model AND type = 'Laptop' 2. SELECT Product.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

 SELECT maker as manufacturer, price, model from Laptop, Product WHERE Laptop.model = Product.model AND Product WHERE ram > 16

 SELECT maker as manufacturer, from Printer, Product WHERE Printer.model = Product.model
 EXCEPT 
 SELECT maker as manufacturer, from Printer, Product WHERE Printer.model = Product.model AND price < 800

SELECT maker as manufacturer, price, model from Laptop, Product WHERE Laptop.model = Product.model AND Product WHERE ram > 16 SELECT maker as manufacturer, from Printer, Product WHERE Printer.model = Product.model EXCEPT SELECT maker as manufacturer, from Printer, Product WHERE Printer.model = Product.model AND price < 800

-- Nov 6 In-Class Exercise Thread

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

-- Nov 6 In-Class Exercise Thread

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

(Edited: 2019-11-06)

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

-- Nov 6 In-Class Exercise Thread

1. SELECT maker AS manufacturer, model, price

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

2. SELECT maker AS manufacturer

   FROM Product
   WHERE Product.type = printer 
   EXCEPT 
   SELECT maker as manufacturer
   FROM Product, PC
   WHERE Product.type = PC AND Product.model = PC.model AND PC.price < 800

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