The following SQL statement selects all products with a price between 10 and 20. In addition; do not show products with a CategoryID of 1,2, or 3:
Example
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20
AND CategoryID NOT IN (1,2,3);
WHERE Price BETWEEN 10 AND 20
AND CategoryID NOT IN (1,2,3);
Practice Excercise Practice now