sqlh5.1

-- Oefening 1

SELECT *
FROM Products
WHERE vend_id = 'BRS01' AND prod_price >= 7;

-- Oefening 2

SELECT *
FROM Products
WHERE vend_id = 'DLL01' OR vend_id = 'BRS01';

-- Oefening 3

SELECT *
FROM Products
WHERE vend_id IN ('DLL01', 'BRS01');

-- Oefening 4

SELECT *
FROM Products
WHERE vend_id = 'DLL01' OR vend_id = 'BRS01' AND prod_price >=10;