CREATE TABLE Maintenance_Work_Order
(
Work_Order_ID varchar (5) not null PRIMARY KEY,
VIN_Number varchar (17) not null 
FOREIGN KEY REFERENCES Vehicles (VIN_Number),
Maintenance_Type_ID varchar (5) not null 
FOREIGN KEY REFERENCES Maintenance_Code(Maintenance_Type_ID),
Assignment_To varchar (9) not null,
Date_Started date not null,
Date_Completed date not null,
Hour_s varchar (7) not null
);
GO
 
 
INSERT into Maintenance_Work_Order VALUES
('H1000','2HNYD28478H501589','MOC4','Blue Team','2012-05-09','2012-05-11','3.0'),
('H1001','2T1FF28PX1C539447','MHR9','Black Team','2012-04-28','2012-04-30','2.75');
 

Q1JFQVRFIFRBQkxFIE1haW50ZW5hbmNlX1dvcmtfT3JkZXIKKApXb3JrX09yZGVyX0lEIHZhcmNoYXIgKDUpIG5vdCBudWxsIFBSSU1BUlkgS0VZLApWSU5fTnVtYmVyIHZhcmNoYXIgKDE3KSBub3QgbnVsbCAKRk9SRUlHTiBLRVkgUkVGRVJFTkNFUyBWZWhpY2xlcyAoVklOX051bWJlciksCk1haW50ZW5hbmNlX1R5cGVfSUQgdmFyY2hhciAoNSkgbm90IG51bGwgCkZPUkVJR04gS0VZIFJFRkVSRU5DRVMgTWFpbnRlbmFuY2VfQ29kZShNYWludGVuYW5jZV9UeXBlX0lEKSwKQXNzaWdubWVudF9UbyB2YXJjaGFyICg5KSBub3QgbnVsbCwKRGF0ZV9TdGFydGVkIGRhdGUgbm90IG51bGwsCkRhdGVfQ29tcGxldGVkIGRhdGUgbm90IG51bGwsCkhvdXJfcyB2YXJjaGFyICg3KSBub3QgbnVsbAopOwpHTwoKCklOU0VSVCBpbnRvIE1haW50ZW5hbmNlX1dvcmtfT3JkZXIgVkFMVUVTCignSDEwMDAnLCcySE5ZRDI4NDc4SDUwMTU4OScsJ01PQzQnLCdCbHVlIFRlYW0nLCcyMDEyLTA1LTA5JywnMjAxMi0wNS0xMScsJzMuMCcpLAooJ0gxMDAxJywnMlQxRkYyOFBYMUM1Mzk0NDcnLCdNSFI5JywnQmxhY2sgVGVhbScsJzIwMTItMDQtMjgnLCcyMDEyLTA0LTMwJywnMi43NScpOwo=

c2VsZWN0ICogZnJvbSBOYW1lcyBXSEVSRSBGbmFtZSA9ICdKb2huJyBBTkQgTG5hbWUgPSAnRG9lJzsK

select * from Names WHERE Fname = 'John' AND Lname = 'Doe';