

insert into vehicle (VIN, Body, Make, Model, P_Year, Capacity, Power, Color, Price, Status, Tax_Nr) values
('WZZ04124124', 'Motorcycle', 'BMW', 'S1000RR', 2015, '999cc', 180, 'white', 16600, false, 'BM15153'),
('WZZ04164123', 'Motorcycle', 'BMW', 'R1200', 2021, '1200cc', 150, 'blue', 21600, false, 'BM15153'),
('WZZ04574121', 'Motorcycle', 'BMW', 'S1000RR', 2024, '999cc', 190, 'red', 28500, false, 'BM15153'),
('WZZ13124666', 'Motorcycle', 'BMW', 'GS310', 2017, '310cc', 50, 'white', 8600, true, 'BM15153'),
('WPY532532EW', 'Motorcycle', 'BMW', 'GS600', 2009, '650cc', 60, 'blue', 5000, true, 'BM15153'),
('PEZ513532RE', 'Car', 'Mercedes', 'E350CDI', 2001, '2998cc', 240, 'red', 4000, false, 'ME15645'),
('PEZ778532MS', 'Car', 'Mercedes', 'C220CDI', 2017, '1999cc', 150, 'purple', 22000, false, 'ME15645'),
('PEZ711532TT', 'Car', 'Mercedes', 'B180CDI', 2012, '1800cc', 110, 'white', 13300, false, 'ME15645'),
('TZZ64127778', 'Van', 'Mercedes', 'Viano', 2020, '2499cc', 120, 'silver', 30000, true, 'ME15645'),
('TZZ04124124', 'Van', 'Mercedes', 'Sprinter', 2020, '3399cc', 130, 'white', 21000, true, 'ME15645'),
('BE135735TTW', 'Car', 'Porsche', '911GT3', 2016, '3999cc', 450, 'white', 113600, true, 'PO16262'),
('BE135175XXT', 'Car', 'Porsche', '911S', 2012, '2999cc', 400, 'blue', 80600, true, 'PO16262'),
('BE131935SSS', 'Car', 'Porsche', 'Cayman', 2021, '2688cc', 350, 'red', 98600, false, 'PO16262'),
('BE135135RES', 'Car', 'Porsche', 'Cayenne', 2024, '3999cc', 400, 'green', 144500, false, 'PO16262'),
('WQT4124215E', 'Car', 'Volkswagen', 'Passat', 2010, '2000cc', 150, 'magenta', 11300, false, 'PO16262'),
('WZOTY124488', 'Car', 'Mini', 'Cooper', 2023, '1500cc', 180, 'yellow', 35600, true, 'BM15153'),
('WZOTX129991', 'Car', 'Mini', 'Clubman', 2007, '1800cc', 150, 'red', 6600, true, 'BM15153'),
('WZOWR126612', 'Car', 'Mini', 'Cooper', 2024, '1500cc', 160, 'white', 38700, false, 'BM15153'),
('WZOTR121111', 'Car', 'Mini', 'One', 2009, '1999cc', 130, 'blue', 5100, true, 'BM15153'),
('WZOTW126311', 'Car', 'BMW', '123d', 2009, '1999cc', 200, 'white', 8900, true, 'BM15153'),
('WZTTR112451', 'Car', 'BMW', '330d', 2024, '2999cc', 2650, 'red', 87000, true, 'BM15153'),
('WZWTR176789', 'Car', 'BMW', '530d', 2017, '2999cc', 230, 'white', 55100, false, 'BM15153'),
('WVCR5332531', 'Van', 'VW', 'Crafter', 2007, '3000cc', 150, 'white', 15100, true, 'PO16262'),
('WUS05215125', 'Truck', 'Scania', '770', 2020, '13000cc', 235, 'purple', 120000, false, 'BM15153'),
('TSR1225331E', 'Truck', 'Mercedes', 'Actros', 2013, '12000cc', 256, 'black', 25000, false, 'ME15645'),
('WUS05266546', 'Truck', 'Scania', '113', 2008, '13000cc', 215, 'purple', 21000, true, 'BM15153');

insert into agreement (A_Id, Price, Status, Datum, Tax_Nr, VIN, EMBG) values
('13A533B', 16600, true, '2023-01-11', 'BM15153', 'WZZ04124124', '1507995410210'),
('16C533B', 21600, true, '2023-05-15', 'BM15153', 'WZZ04164123', '1507995410210'),
('13A674A', 28500, true, '2023-08-01', 'BM15153', 'WZZ04574121', '2010997410030'),
('13543HH', 120000, true, '2023-11-15', 'BM15153', 'WUS05215125', '2010997410030'),
('19832H8', 38700, true, '2023-12-22', 'BM15153', 'WZOWR126612', '1107975510760'),
('1870G8F', 55100, true, '2023-07-02', 'BM15153', 'WZWTR176789', '1108456710760'),
('12223G3', 98600, true, '2023-02-11', 'PO16262', 'BE131935SSS', '1306999410160'),
('189523G', 144500, true, '2023-10-10', 'PO16262', 'BE135135RES', '1107977410760'),
('2532G7G', 11300, true, '2023-11-22', 'PO16262', 'WQT4124215E', '1107975510760'),
('83252GG', 4000, true, '2023-01-06', 'ME15645', 'PEZ513532RE', '1507995410210'),
('67FAS55', 22000, true, '2023-04-26', 'ME15645', 'PEZ778532MS', '1176552310760'),
('43F77FD', 13300, true, '2023-08-01', 'ME15645', 'PEZ711532TT', '1108456710760'),
('38G843F', 25000, true, '2023-09-16', 'ME15645', 'TSR1225331E', '1306999410160');
