SQL for SELECT with criteria
exercises:
SELECT ProductName, SupplierID,
UnitPrice
FROM Products
ORDER BY ProductName;
SELECT ProductName, SupplierID,
UnitPrice
FROM Products
WHERE UnitPrice <= 10
ORDER BY ProductName;
SELECT ProductName, SupplierID,
UnitPrice
FROM Products
WHERE UnitPrice BETWEEN 10 AND 20
ORDER BY ProductName;
SELECT ProductName, SupplierID,
UnitPrice
FROM Products
WHERE ProductName LIKE
"*Choc*"
OR ProductName LIKE
"*Schok*"
ORDER BY ProductName;