Yioop - PHP Search Engine

-- Nov 7 In-Class Exercise

1)

 SELECT Product.maker, Printer.price, Printer.type 
 FROM 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 Product.maker, Printer.price, Printer.type FROM 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, type FROM Product, Printer WHERE Product.model = Printer.model AND Printer.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 PC.price < 1000)

(Edited: 2018-11-08)

1. SELECT maker, price, type FROM Product, Printer WHERE Product.model = Printer.model AND Printer.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 PC.price < 1000)

-- Nov 7 In-Class Exercise

1. SELECT maker, price and type FROM Product, Printer WHERE Product.model = Printer.model AND Printer.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 PC.price < 1000)

1. SELECT maker, price and type FROM Product, Printer WHERE Product.model = Printer.model AND Printer.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 PC.price < 1000)

-- Nov 7 In-Class Exercise

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

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

1. SELECT maker, price, type FROM Product, Printer WHERE Printer.color = 'green' AND Product.model = Printer.model; 2. SELECT maker FROM Product, Laptop WHERE Product.model = Laptop.model EXCEPT SELECT maker FROM Product, PC WHERE Product.model = PC.model AND PC.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-11)

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, Printer.type
FROM Printer, Product
WHERE color = ‘green’ AND Product.model = Printer.model

2. SELECT maker
FROM Product, Laptop
WHERE Product.model = Laptop.model
EXCEPT
SELECT maker
FROM Product, PC
WHERE price < 1000 AND Product.model = PC.model

(Edited: 2018-11-12)

1. SELECT maker, price, Printer.type FROM Printer, Product WHERE color = ‘green’ AND Product.model = Printer.model 2. SELECT maker FROM Product, Laptop WHERE Product.model = Laptop.model EXCEPT SELECT maker FROM Product, PC WHERE price < 1000 AND Product.model = PC.model

-- Nov 7 In-Class Exercise

1). SELECT maker, price, Printer.type FROM Printer, Product WHERE color = ‘green’ AND Product.model = Printer.model;

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

1). SELECT maker, price, Printer.type FROM Printer, Product WHERE color = ‘green’ AND Product.model = Printer.model; 2). (SELECT maker FROM Product, Laptop WHERE Product.model = Laptop.model) EXCEPT (SELECT maker FROM Product, PC WHERE price < 1000 AND Product.model = PC.model);

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

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

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