-
Select the names of all the products in the store ?
SELECT Name FROM Products; -
Select the names and the prices of all the products in the store ?
SELECT Name, Price FROM Products; -
Select the name of the products with a price less than or equal to 200 ?
SELECT Name FROM Products WHERE Price <= 200; -
Select all the products with a price between 60 and 120 ?
/* With AND */
SELECT * FROM Products
WHERE Price >= 60 AND Price <= 120;
/* With BETWEEN */
SELECT * FROM Products
WHERE Price BETWEEN 60 AND 120;