Create table `Products`
( `prod_id` VARCHAR (3) NOT NULL
, `prod_name` VARCHAR (20) NOT NULL
, `prod_price` DOUBLE NOT NULL
, `vend_id` VARCHAR (10) NOT NULL
);
INSERT INTO `Products` VALUES
("7", "Banana", 10, 1),
("2", "Cucumber", 1000, "2"),
("3", "Corn", 12, "3"),
("4", "Slave", 9999, "4"),
("1", "~pi", 3.49, "5"),
("6", "Wut?", 777, "DLL01")
;
SELECT prod_id, prod_name, prod_price FROM `Products` WHERE prod_name="Slave" OR prod_price>999;
SELECT prod_id, prod_name, prod_price FROM `Products` WHERE prod_price IN (10, 1000);
SELECT prod_id, prod_name, prod_price FROM `Products` WHERE vend_id NOT IN ("DLL01");
SELECT prod_id, prod_name, prod_price FROM `Products` WHERE prod_name LIKE "c%";
Telegram: DB developers channel