Advanced Data Filtering

Question 1

AND + OR

Answer 1

SELECT prod_name, prod_price
FROM Products
WHERE (vend_id = ‘DLL01’ OR vend_id = ‘BRS01’)
AND prod_price >= 10;

Question 2

IN or NOT IN

Answer 2

SELECT prod_name, prod_price
FROM Products
WHERE vend_id IN (‘DLL01’,’BRS01’)
ORDER BY prod_name;

IN can contain another SELECT statement
IN executes faster than list of OR operators