USE assignment2;

INSERT INTO customers(first_name, last_name, email, phoneNo, shipping_detail_id)
	VALUES('Jake', 'Smith', 'jakesmith@email.com', 1236548780, (SELECT shipping_detail_id FROM shipping_details WHERE address LIKE 'yknhl fr hluhw'));
    
UPDATE invoice
	SET amount=147
    WHERE invoice_no=279971;
    
DELETE FROM customers
	WHERE email LIKE 'gndyvdijgw@email.com';