INSERT INTO Customers (FirstName, LastName, Mobile, Country, Email)
VALUES ('Tom','Kelly','0893672867','Ireland','TomKelly@yahoo.ie'),
	   ('John','Kelly','0896757835','Ireland','JohnKelly@yahoo.ie'),
	   ('Mark','Healy','0896757835','Ireland','Mark@gmail.com');



INSERT INTO CAR (CarColour, CarBrand, CarModel, PurchaseDate)
VALUES ('Blue','Hyundai I10','I10',CURDATE()),
	   ('red','Ford Fiesta ','Fiesta',CURDATE()),
	   ('white','Hyundai Tucson','Tucson',CURDATE());



INSERT INTO Orders (Date, CustID, CarID)
VALUES (CURDATE(),1,1),
	   (CURDATE(),2,2),
	   (CURDATE(),3,3);