sqlh15.1

-- Oefening 1

INSERT INTO Customers
VALUES (1000000006,
        'Toy Land',
        '123 Any Street',
        'New York',
        'NY',
        11111,
        'USA',
        NULL,
        NULL);

-- Oefening 2

INSERT INTO Customers (	cust_id, 
						cust_name, 
						cust_address, 
						cust_city, 
						cust_state, 
						cust_zip, 
						cust_country)
VALUES (1000000007,
        'Toy Land',
        '123 Any Street',
        'New York',
        'NY',
        11111,
        'USA');

-- Oefening 3

INSERT INTO Orders (order_num,
					order_date,
					cust_id)
VALUES (20010,
		GETDATE(),
		1000000007);

-- MySQL
INSERT INTO Orders (order_num,
                                        order_date,
                                        cust_id)
VALUES (20010,
                NOW(),
                1000000007)