sqlh16.1

-- Oefening 1

UPDATE Customers
SET cust_name = 'Intertoys B.V.'
WHERE cust_id BETWEEN 1000000008 AND 1000000010;

-- Oefening 2

DELETE Customers
WHERE cust_id = 1000000007;

-- Oefening 3

DELETE OrderItems 
WHERE order_num = 20010

DELETE Orders 
WHERE order_num = 20010

DELETE Customers
WHERE cust_id = 1000000007;

Download hier het bestand.