create table kliendiAuto (
	id INT PRIMARY KEY,
	first_name VARCHAR(50),
	last_name VARCHAR(50),
	email VARCHAR(50),
	car_make VARCHAR(50),
	car_model VARCHAR(50),
	car_year INT(50),
	car_price DECIMAL(7,2)
);

insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (1, 'Julita', 'D''Oyley', 'jdoyley0@gmpg.org', 'Audi', 'A8', 2012, 3256.93);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, 'Gram', 'Diter', 'gditer1@geocities.jp', 'Jeep', 'Grand Cherokee', 2001, 5698.52);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, 'Klarrisa', 'Cratere', 'kcratere2@globo.com', 'Land Rover', 'Range Rover', 1994, 5317.66);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, 'Sharona', 'Clubbe', 'sclubbe3@sina.com.cn', 'Plymouth', 'Voyager', 1997, 3818.75);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (5, 'Adella', 'Hasty', 'ahasty4@e-recht24.de', 'Lincoln', 'Town Car', 1984, 5897.84);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (6, 'Kelley', 'Philbrick', 'kphilbrick5@ameblo.jp', 'Chevrolet', 'Corvette', 1969, 1692.15);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (7, 'Ursulina', 'Aldhouse', 'ualdhouse6@google.com.au', 'Infiniti', 'Q', 2003, 1237.53);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (8, 'Arthur', 'Dawks', 'adawks7@boston.com', 'Dodge', 'Ram 1500 Club', 1997, 4666.3);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (9, 'Myrlene', 'Brabban', 'mbrabban8@reddit.com', 'Hyundai', 'Santa Fe', 2012, 7720.97);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (10, 'Kayley', 'Wittering', 'kwittering9@kickstarter.com', 'Audi', 'S4', 1993, 6584.75);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (11, 'Noreen', 'Donoghue', 'ndonoghuea@spotify.com', 'Mitsubishi', 'GTO', 1995, 5370.45);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (12, 'Lyndell', 'Grane', 'lgraneb@digg.com', 'Lexus', 'GS', 1997, 2555.09);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (13, 'Devin', 'Dell Casa', 'ddellcasac@eepurl.com', 'Plymouth', 'Voyager', 2000, 6263.08);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (14, 'Winonah', 'Iglesia', 'wiglesiad@chronoengine.com', 'Dodge', 'Avenger', 1999, 1700.84);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (15, 'Filippa', 'Kacheler', 'fkachelere@archive.org', 'Oldsmobile', 'Intrigue', 2002, 9964.27);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (16, 'Callie', 'Scaife', 'cscaifef@ow.ly', 'Land Rover', 'Discovery Series II', 2001, 6777.19);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (17, 'Grata', 'Arnaldi', 'garnaldig@apple.com', 'Honda', 'FCX Clarity', 2012, 6804.5);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (18, 'Merrel', 'Robelow', 'mrobelowh@shop-pro.jp', 'Alfa Romeo', '164', 1992, 7801.36);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (19, 'Nap', 'Raspison', 'nraspisoni@indiatimes.com', 'Lexus', 'RX', 2005, 6248.13);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (20, 'Araldo', 'Bodiam', 'abodiamj@mediafire.com', 'Ford', 'F-Series Super Duty', 2011, 6654.63);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (21, 'Desmond', 'Tasker', 'dtaskerk@forbes.com', 'Nissan', '200SX', 1996, 2501.29);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (22, 'Anastassia', 'Dixon', 'adixonl@pagesperso-orange.fr', 'Subaru', 'Outback', 2011, 9490.99);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (23, 'Jeanine', 'Skupinski', 'jskupinskim@wikia.com', 'Mazda', 'Mazdaspeed 3', 2007, 2588.2);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (24, 'Dicky', 'Griggs', 'dgriggsn@miibeian.gov.cn', 'Volkswagen', 'CC', 2009, 1653.44);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (25, 'Donelle', 'Burkill', 'dburkillo@senate.gov', 'Dodge', 'Durango', 2001, 8650.2);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (26, 'Haroun', 'Cheel', 'hcheelp@reverbnation.com', 'Volkswagen', 'rio', 1996, 7977.38);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (27, 'Terencio', 'O''Lenechan', 'tolenechanq@cmu.edu', 'Buick', 'Skylark', 1996, 1231.14);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (28, 'Tiffanie', 'Belz', 'tbelzr@yelp.com', 'Porsche', '968', 1993, 482.08);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (29, 'Vite', 'Templeman', 'vtemplemans@timesonline.co.uk', 'Pontiac', 'Tempest', 1965, 954.03);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (30, 'Esther', 'Cuckoo', 'ecuckoot@hubpages.com', 'Jeep', 'Commander', 2007, 4236.3);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (31, 'Derby', 'Dearan', 'ddearanu@jiathis.com', 'GMC', 'Acadia', 2008, 5586.45);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (32, 'Ellary', 'Leighfield', 'eleighfieldv@soundcloud.com', 'Toyota', 'Camry', 2002, 4418.11);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (33, 'Cacilie', 'Heinsius', 'cheinsiusw@ebay.com', 'Saturn', 'L-Series', 2002, 3871.5);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (34, 'Stepha', 'Lambole', 'slambolex@naver.com', 'Dodge', 'Intrepid', 2002, 2947.86);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (35, 'Micki', 'Brashaw', 'mbrashawy@dot.gov', 'Chevrolet', 'Avalanche', 2002, 3837.97);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (36, 'Jillane', 'O''Hone', 'johonez@engadget.com', 'GMC', '1500', 1994, 2313.9);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (37, 'Kylila', 'Ninnoli', 'kninnoli10@theatlantic.com', 'Dodge', 'Ram Wagon B350', 1993, 8963.88);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (38, 'Llywellyn', 'Trill', 'ltrill11@narod.ru', 'Acura', 'Integra', 2000, 5619.99);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (39, 'Mel', 'Lanbertoni', 'mlanbertoni12@ft.com', 'Chrysler', 'PT Cruiser', 2008, 3363.59);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (40, 'Ailee', 'Moberley', 'amoberley13@skyrock.com', 'Chevrolet', 'Cavalier', 1994, 8104.73);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (41, 'Wain', 'Bacop', 'wbacop14@myspace.com', 'Lamborghini', 'Countach', 1989, 1827.87);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (42, 'Gannie', 'Mcall', 'gmcall15@va.gov', 'Mercury', 'Topaz', 1989, 7378.01);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (43, 'Dennison', 'Marchi', 'dmarchi16@cocolog-nifty.com', 'Pontiac', 'Grand Prix', 1975, 6331.61);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (44, 'Cordula', 'Wagge', 'cwagge17@hao123.com', 'Toyota', 'Corolla', 2005, 9981.34);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (45, 'Gonzalo', 'Biasioni', 'gbiasioni18@com.com', 'Audi', '5000S', 1987, 5269.0);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (46, 'Aubrey', 'Stanhope', 'astanhope19@scientificamerican.com', 'Mitsubishi', 'GTO', 1995, 1675.23);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (47, 'Tatiana', 'Bristoe', 'tbristoe1a@purevolume.com', 'Mercedes-Benz', 'CLK-Class', 2005, 2146.91);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (48, 'Doralia', 'Scheu', 'dscheu1b@comsenz.com', 'Chevrolet', 'Impala', 2003, 1066.58);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (49, 'Saw', 'Antuk', 'santuk1c@vimeo.com', 'Mazda', '929', 1989, 8223.84);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (50, 'Sawyer', 'Rosenbush', 'srosenbush1d@free.fr', 'Ford', 'Escape', 2010, 4407.63);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (51, 'Matias', 'Ullrich', 'mullrich1e@flickr.com', 'Pontiac', 'Firefly', 1984, 2399.43);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (52, 'Shell', 'Gercke', 'sgercke1f@hexun.com', 'Morgan', 'Aero 8', 2006, 7222.0);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (53, 'Albertine', 'Spancock', 'aspancock1g@bizjournals.com', 'Mercury', 'Mountaineer', 2007, 5802.72);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (54, 'Pacorro', 'Scotting', 'pscotting1h@xing.com', 'Cadillac', 'STS', 2011, 158.43);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (55, 'Sibelle', 'Higounet', 'shigounet1i@pbs.org', 'Chrysler', 'Voyager', 2000, 6582.37);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (56, 'Ignacio', 'Spaunton', 'ispaunton1j@newsvine.com', 'Honda', 'Pilot', 2003, 9315.66);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (57, 'Manolo', 'Beat', 'mbeat1k@zimbio.com', 'Mazda', 'Protege', 1998, 2264.07);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (58, 'Phaidra', 'Easter', 'peaster1l@i2i.jp', 'Ford', 'Club Wagon', 1993, 1952.34);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (59, 'Rebecca', 'Zupone', 'rzupone1m@unblog.fr', 'Toyota', 'MR2', 1985, 9121.47);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (60, 'Anet', 'Thirtle', 'athirtle1n@nba.com', 'Volkswagen', 'Type 2', 1990, 7977.93);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (61, 'Mil', 'Lyver', 'mlyver1o@flavors.me', 'Ford', 'Edge', 2010, 5215.04);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (62, 'Jaime', 'MacElharge', 'jmacelharge1p@howstuffworks.com', 'Saturn', 'L-Series', 2000, 2297.18);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (63, 'Bernhard', 'Ubach', 'bubach1q@dyndns.org', 'Lotus', 'Evora', 2011, 6211.26);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (64, 'Sonya', 'Stocker', 'sstocker1r@github.io', 'Nissan', 'Versa', 2009, 413.03);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (65, 'Kellsie', 'Anselmi', 'kanselmi1s@vkontakte.ru', 'Ford', 'F350', 1995, 3417.85);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (66, 'Saundra', 'Elvish', 'selvish1t@smh.com.au', 'Toyota', 'Land Cruiser', 2003, 2848.7);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (67, 'Herbie', 'Liepina', 'hliepina1u@bing.com', 'Oldsmobile', 'Ciera', 1994, 2917.97);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (68, 'Lea', 'Aldam', 'laldam1v@huffingtonpost.com', 'Ford', 'E150', 2010, 1103.97);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (69, 'Dita', 'Martinson', 'dmartinson1w@amazon.de', 'Ford', 'Explorer', 1993, 4918.57);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (70, 'Gena', 'Izakov', 'gizakov1x@hubpages.com', 'Honda', 'CR-V', 2004, 2240.26);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (71, 'Clio', 'Shippard', 'cshippard1y@flickr.com', 'Infiniti', 'QX', 2012, 8291.87);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (72, 'Bayard', 'Flewitt', 'bflewitt1z@amazon.com', 'Audi', '100', 1991, 2006.43);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (73, 'Georgie', 'Plumbridge', 'gplumbridge20@yellowpages.com', 'Chevrolet', 'Cavalier', 2000, 8520.28);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (74, 'Stella', 'Lakenden', 'slakenden21@umn.edu', 'Buick', 'LeSabre', 1986, 429.08);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (75, 'Eziechiele', 'Garrattley', 'egarrattley22@ca.gov', 'Chevrolet', 'Corvette', 1957, 6993.77);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (76, 'Melita', 'Boggis', 'mboggis23@youtu.be', 'Aston Martin', 'DB9', 2011, 6171.69);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (77, 'Cordey', 'Yesinov', 'cyesinov24@drupal.org', 'Chevrolet', 'Suburban 1500', 1993, 1090.45);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (78, 'Bernie', 'MacDowall', 'bmacdowall25@google.fr', 'Maybach', '57', 2003, 1950.84);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (79, 'Dusty', 'Brusin', 'dbrusin26@skype.com', 'Volkswagen', 'rio', 1997, 2873.2);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (80, 'Ursuline', 'Gosnold', 'ugosnold27@lycos.com', 'Ford', 'Escape', 2012, 5389.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (81, 'Gerardo', 'Dmitrienko', 'gdmitrienko28@etsy.com', 'Ford', 'Transit Connect', 2011, 1258.37);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (82, 'Marice', 'Clayden', 'mclayden29@nbcnews.com', 'Pontiac', 'Bonneville', 2003, 9071.69);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (83, 'Violetta', 'Worthington', 'vworthington2a@ihg.com', 'Chevrolet', 'Cavalier', 1996, 180.16);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (84, 'El', 'Marquese', 'emarquese2b@php.net', 'Chevrolet', 'Malibu', 2004, 5547.73);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (85, 'Kristo', 'Alastair', 'kalastair2c@google.ru', 'Dodge', 'Charger', 2007, 1913.26);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (86, 'Enos', 'Fennelow', 'efennelow2d@flavors.me', 'Toyota', 'Avalon', 2007, 1457.54);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (87, 'Jessey', 'Pollen', 'jpollen2e@flavors.me', 'Nissan', '200SX', 1996, 2563.89);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (88, 'Burch', 'Stockow', 'bstockow2f@earthlink.net', 'Acura', 'Legend', 1987, 5881.18);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (89, 'Maryjane', 'Funcheon', 'mfuncheon2g@macromedia.com', 'Mercedes-Benz', 'SL-Class', 1989, 606.33);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (90, 'Giacobo', 'Piggott', 'gpiggott2h@blogtalkradio.com', 'Acura', 'TL', 1998, 9340.52);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (91, 'Selie', 'Tiebe', 'stiebe2i@nba.com', 'GMC', 'Sierra 1500', 2005, 3777.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (92, 'Zelma', 'Sandeson', 'zsandeson2j@ask.com', 'Cadillac', 'Escalade EXT', 2011, 5950.48);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (93, 'Den', 'Wigin', 'dwigin2k@who.int', 'GMC', 'Sierra', 2012, 9210.11);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (94, 'Aubrette', 'Samter', 'asamter2l@exblog.jp', 'Kia', 'Sorento', 2013, 4223.94);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (95, 'Lorne', 'Pilipyak', 'lpilipyak2m@vimeo.com', 'Mercedes-Benz', 'SLR McLaren', 2007, 3194.83);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (96, 'Brett', 'Staning', 'bstaning2n@pinterest.com', 'Volkswagen', 'Passat', 2003, 7615.57);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (97, 'Alberik', 'Culleton', 'aculleton2o@webmd.com', 'Mitsubishi', 'Chariot', 1989, 3051.55);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (98, 'Jennilee', 'Novacek', 'jnovacek2p@soundcloud.com', 'Ford', 'Tempo', 1986, 6555.81);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (99, 'Erl', 'Benezeit', 'ebenezeit2q@over-blog.com', 'Honda', 'Insight', 2005, 1778.35);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (100, 'Oriana', 'Janczewski', 'ojanczewski2r@qq.com', 'Daewoo', 'Lanos', 2000, 286.99);

UPDATE kliendiauto
SET car_model = 'Zaporozec'
WHERE id = 101 OR id = 102 OR id = 103;

SELECT * FROM kliendiauto
WHERE id = 101 OR id = 102 OR id = 103;

UPDATE kliendiauto
set car_model = 'Citroen'
where car_make like 'cadillac';

SELECT * from  kliendiauto
WHERE car_make like 'cadillac';

DELETE FROM kliendiauto
WHERE id IN (5, 10, 15);

SELECT id, last_name, car_make, car_year
FROM kliendiauto
ORDER BY id ASC;

SELECT * FROM kliendiauto
WHERE last_name LIKE 'S%'
ORDER BY car_year DESC
LIMIT 10;

SELECT * FROM kliendiauto 
WHERE car_make IN ('Audi', 'Lexus') 
AND car_price > 1000;

SELECT AVG(car_price) as 'avarage price', sum(car_price) AS 'sum price'
from kliendiauto

create table autorent (
	id INT PRIMARY KEY,
	date_time DATE,
	full_name VARCHAR(50),
	email VARCHAR(50),
	auto_hind VARCHAR(50),
	cliendiAutoID INT,
	FOREIGN KEY (cliendiAutoID) REFERENCES kliendiauto(id)
);

insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (1, '2023-12-15', 'Grady Londesborough', 'glondesborough0@wisc.edu', '€186,66', 1);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (2, '2023-04-20', 'Janot Guisot', 'jguisot1@yahoo.com', '€184,86', 2);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (3, '2024-02-20', 'Jonell Wagon', 'jwagon2@earthlink.net', '€172,30', 3);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (4, '2023-06-18', 'Osbert Clelle', 'oclelle3@csmonitor.com', '€496,20', 4);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (5, '2023-08-11', 'Isabella Waud', 'iwaud4@list-manage.com', '€454,47', 5);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (6, '2023-12-19', 'Anthe Hawkeridge', 'ahawkeridge5@slideshare.net', '€363,07', 6);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (7, '2024-02-15', 'Katlin de Castelain', 'kde6@netlog.com', '€360,55', 7);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (8, '2023-12-05', 'Marilin Holleran', 'mholleran7@cam.ac.uk', '€372,00', 8);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (9, '2023-10-22', 'Kettie Fairtlough', 'kfairtlough8@nyu.edu', '€468,41', 9);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (10, '2023-06-04', 'Minda Abrahamowitcz', 'mabrahamowitcz9@dagondesign.com', '€309,32', 10);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (11, '2024-03-29', 'Wanids Breckell', 'wbreckella@gizmodo.com', '€497,93', 11);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (12, '2023-04-30', 'Britni Rolin', 'brolinb@cam.ac.uk', '€174,75', 12);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (13, '2024-02-08', 'Violetta Grinaugh', 'vgrinaughc@ca.gov', '€236,54', 13);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (14, '2023-09-21', 'Trevar Sabben', 'tsabbend@chronoengine.com', '€251,63', 14);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (15, '2023-08-27', 'Maria Maliphant', 'mmaliphante@ftc.gov', '€133,61', 15);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (16, '2023-10-11', 'Harlene De la Yglesias', 'hdef@bigcartel.com', '€381,99', 16);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (17, '2023-11-26', 'Maddi Zellmer', 'mzellmerg@imdb.com', '€408,84', 17);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (18, '2023-12-11', 'Hyacintha Dobbson', 'hdobbsonh@nytimes.com', '€290,44', 18);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (19, '2023-08-02', 'Larine Offield', 'loffieldi@constantcontact.com', '€159,69', 19);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (20, '2024-02-03', 'Mandy Eskriett', 'meskriettj@mlb.com', '€330,16', 20);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (21, '2024-01-30', 'Bendite Connick', 'bconnickk@miitbeian.gov.cn', '€195,32', 21);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (22, '2023-09-05', 'Clarisse Guild', 'cguildl@house.gov', '€498,63', 22);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (23, '2023-12-31', 'Ernie Venditto', 'evendittom@artisteer.com', '€294,89', 23);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (24, '2023-12-25', 'Cece Folli', 'cfollin@fotki.com', '€428,44', 24);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (25, '2024-01-13', 'Ivie Dugget', 'iduggeto@merriam-webster.com', '€330,17', 25);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (26, '2024-04-01', 'Hew Duguid', 'hduguidp@ovh.net', '€155,51', 26);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (27, '2023-04-14', 'Abner Dearnly', 'adearnlyq@baidu.com', '€349,51', 27);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (28, '2024-01-01', 'Wendie Ghiroldi', 'wghiroldir@apache.org', '€498,39', 28);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (29, '2023-07-27', 'Bartel Woollin', 'bwoollins@boston.com', '€476,74', 29);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (30, '2023-07-10', 'Denice Phateplace', 'dphateplacet@devhub.com', '€413,54', 30);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (31, '2023-04-20', 'Garret Patemore', 'gpatemoreu@feedburner.com', '€138,28', 31);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (32, '2023-11-06', 'Egbert Cosely', 'ecoselyv@biglobe.ne.jp', '€368,09', 32);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (33, '2023-05-12', 'Vania Harry', 'vharryw@techcrunch.com', '€268,26', 33);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (34, '2023-09-15', 'Ailbert Vinter', 'avinterx@acquirethisname.com', '€462,24', 34);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (35, '2023-12-20', 'Sam Grinaugh', 'sgrinaughy@ocn.ne.jp', '€330,20', 35);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (36, '2023-08-20', 'Louie Schuh', 'lschuhz@biglobe.ne.jp', '€204,59', 36);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (37, '2024-02-18', 'Esmaria Wilkennson', 'ewilkennson10@naver.com', '€250,13', 37);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (38, '2024-02-14', 'Georgina Denley', 'gdenley11@canalblog.com', '€307,91', 38);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (39, '2023-11-15', 'Ivonne Gareisr', 'igareisr12@indiegogo.com', '€193,59', 39);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (40, '2023-08-21', 'Randee Beetham', 'rbeetham13@oracle.com', '€386,10', 40);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (41, '2023-10-04', 'Aleece Ineson', 'aineson14@elpais.com', '€120,34', 41);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (42, '2023-09-30', 'Bronson Younie', 'byounie15@elpais.com', '€445,00', 42);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (43, '2023-06-22', 'Ulla Hazelton', 'uhazelton16@bandcamp.com', '€225,02', 43);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (44, '2023-08-06', 'Hobie Eddy', 'heddy17@state.gov', '€121,73', 44);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (45, '2023-08-05', 'Conney De Micoli', 'cde18@adobe.com', '€205,38', 45);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (46, '2023-07-11', 'Doria Eldershaw', 'deldershaw19@networksolutions.com', '€141,41', 46);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (47, '2023-12-18', 'Jacquetta Dowse', 'jdowse1a@aboutads.info', '€494,74', 47);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (48, '2024-03-10', 'Harv Merrgan', 'hmerrgan1b@free.fr', '€142,42', 48);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (49, '2023-09-14', 'Louella Cardenoza', 'lcardenoza1c@issuu.com', '€123,10', 49);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (50, '2023-08-03', 'Norry Westhead', 'nwesthead1d@illinois.edu', '€281,88', 50);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (51, '2024-02-01', 'Brent Hakking', 'bhakking1e@engadget.com', '€242,58', 51);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (52, '2023-04-22', 'Noach Petican', 'npetican1f@state.tx.us', '€416,58', 52);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (53, '2023-05-12', 'Wilone Ridsdole', 'wridsdole1g@meetup.com', '€484,31', 53);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (54, '2023-10-15', 'Carling Ivanaev', 'civanaev1h@oaic.gov.au', '€393,50', 54);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (55, '2023-10-31', 'Ladonna Antoni', 'lantoni1i@sohu.com', '€412,01', 55);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (56, '2023-10-13', 'Geoffrey Mates', 'gmates1j@blog.com', '€309,40', 56);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (57, '2023-08-22', 'Lucio Wilks', 'lwilks1k@dmoz.org', '€395,65', 57);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (58, '2023-04-16', 'Jeannine Broske', 'jbroske1l@dedecms.com', '€340,54', 58);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (59, '2024-03-23', 'Brandea Chiplin', 'bchiplin1m@java.com', '€102,77', 59);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (60, '2023-11-13', 'Roddie Szymanowski', 'rszymanowski1n@free.fr', '€465,22', 60);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (61, '2023-07-07', 'Rubia Rosario', 'rrosario1o@indiegogo.com', '€203,93', 61);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (62, '2024-03-19', 'Casey Marczyk', 'cmarczyk1p@gnu.org', '€412,24', 62);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (63, '2023-09-04', 'Candis Insoll', 'cinsoll1q@ifeng.com', '€151,34', 63);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (64, '2024-03-24', 'Dina Simms', 'dsimms1r@cpanel.net', '€239,24', 64);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (65, '2023-09-20', 'Gordon Phillipps', 'gphillipps1s@kickstarter.com', '€162,45', 65);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (66, '2023-04-10', 'Evita Middell', 'emiddell1t@123-reg.co.uk', '€139,61', 66);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (67, '2023-10-18', 'Selby McGee', 'smcgee1u@weather.com', '€118,17', 67);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (68, '2023-10-25', 'Sibby Rubke', 'srubke1v@t.co', '€143,77', 68);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (69, '2023-10-19', 'Penny Begent', 'pbegent1w@nature.com', '€233,37', 69);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (70, '2023-10-18', 'Nikoletta MacDermand', 'nmacdermand1x@dot.gov', '€133,83', 70);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (71, '2024-02-28', 'Waiter Cluckie', 'wcluckie1y@symantec.com', '€362,31', 71);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (72, '2023-10-31', 'Tome Vidineev', 'tvidineev1z@nydailynews.com', '€297,31', 72);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (73, '2023-10-15', 'Darell Accomb', 'daccomb20@engadget.com', '€449,89', 73);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (74, '2024-04-01', 'Tiffy Salaman', 'tsalaman21@state.tx.us', '€116,35', 74);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (75, '2024-01-17', 'Melinda Chicco', 'mchicco22@delicious.com', '€376,93', 75);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (76, '2023-12-30', 'Nathaniel Hebburn', 'nhebburn23@elpais.com', '€297,59', 76);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (77, '2024-01-18', 'Les MacMarcuis', 'lmacmarcuis24@t.co', '€254,55', 77);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (78, '2023-12-18', 'Webster McDuffie', 'wmcduffie25@issuu.com', '€330,65', 78);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (79, '2023-07-21', 'Jamil Doul', 'jdoul26@sphinn.com', '€337,70', 79);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (80, '2024-03-13', 'Kattie Marrian', 'kmarrian27@merriam-webster.com', '€223,03', 80);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (81, '2023-06-12', 'Lettie Raynham', 'lraynham28@xing.com', '€146,95', 81);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (82, '2023-10-11', 'Hillard Shailer', 'hshailer29@discovery.com', '€212,54', 82);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (83, '2023-09-15', 'Cort Pierson', 'cpierson2a@xinhuanet.com', '€140,13', 83);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (84, '2023-09-20', 'Clementius MacDonough', 'cmacdonough2b@behance.net', '€138,15', 84);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (85, '2023-12-01', 'Lois Issacof', 'lissacof2c@alibaba.com', '€265,97', 85);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (86, '2023-06-08', 'Dore Gogie', 'dgogie2d@furl.net', '€463,02', 86);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (87, '2024-04-02', 'Andras Relf', 'arelf2e@trellian.com', '€364,17', 87);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (88, '2024-01-24', 'Horst Tubble', 'htubble2f@census.gov', '€161,34', 88);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (89, '2024-01-27', 'Jaye MacKean', 'jmackean2g@discuz.net', '€493,62', 89);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (90, '2023-06-13', 'Amanda Whitmore', 'awhitmore2h@ftc.gov', '€156,41', 90);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (91, '2023-11-12', 'Roxanna Lineham', 'rlineham2i@statcounter.com', '€488,61', 91);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (92, '2023-11-20', 'Saxon Goodbairn', 'sgoodbairn2j@blogger.com', '€498,19', 92);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (93, '2023-05-12', 'Garik McGrae', 'gmcgrae2k@yahoo.com', '€314,62', 93);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (94, '2023-07-09', 'Michal Dilke', 'mdilke2l@studiopress.com', '€436,64', 94);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (95, '2024-03-20', 'Abdel MacMichael', 'amacmichael2m@yellowbook.com', '€361,43', 95);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (96, '2023-11-26', 'Alexandrina Woolfoot', 'awoolfoot2n@deviantart.com', '€253,55', 96);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (97, '2023-07-30', 'Emyle Escoffier', 'eescoffier2o@smh.com.au', '€101,73', 97);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (98, '2023-08-20', 'Pincus Hubball', 'phubball2p@constantcontact.com', '€280,79', 98);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (99, '2023-12-02', 'Opaline Caiger', 'ocaiger2q@google.ca', '€103,43', 99);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (100, '2023-11-11', 'Valenka Robilliard', 'vrobilliard2r@ted.com', '€403,91', 100);

create table kliendiAuto (
	id INT PRIMARY KEY,
	first_name VARCHAR(50),
	last_name VARCHAR(50),
	email VARCHAR(50),
	car_make VARCHAR(50),
	car_model VARCHAR(50),
	car_year INT,
	car_price INT
);

insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (1, 'Julita', 'D''Oyley', 'jdoyley0@gmpg.org', 'Audi', 'A8', 2012, 3256.93);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, 'Gram', 'Diter', 'gditer1@geocities.jp', 'Jeep', 'Grand Cherokee', 2001, 5698.52);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, 'Klarrisa', 'Cratere', 'kcratere2@globo.com', 'Land Rover', 'Range Rover', 1994, 5317.66);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, 'Sharona', 'Clubbe', 'sclubbe3@sina.com.cn', 'Plymouth', 'Voyager', 1997, 3818.75);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (5, 'Adella', 'Hasty', 'ahasty4@e-recht24.de', 'Lincoln', 'Town Car', 1984, 5897.84);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (6, 'Kelley', 'Philbrick', 'kphilbrick5@ameblo.jp', 'Chevrolet', 'Corvette', 1969, 1692.15);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (7, 'Ursulina', 'Aldhouse', 'ualdhouse6@google.com.au', 'Infiniti', 'Q', 2003, 1237.53);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (8, 'Arthur', 'Dawks', 'adawks7@boston.com', 'Dodge', 'Ram 1500 Club', 1997, 4666.3);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (9, 'Myrlene', 'Brabban', 'mbrabban8@reddit.com', 'Hyundai', 'Santa Fe', 2012, 7720.97);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (10, 'Kayley', 'Wittering', 'kwittering9@kickstarter.com', 'Audi', 'S4', 1993, 6584.75);

UPDATE kliendiauto
SET car_model = 'Zaporozec'
WHERE id = 11 OR id = 12 OR id = 13;

UPDATE KliendiAuto
set car_make = 'Jeep'
where car_make like 'cadillac';

DELETE FROM kliendiauto
WHERE id IN (5, 10, 15);

SELECT id, last_name, car_make, car_year
FROM kliendiauto
ORDER BY id ASC;

SELECT * FROM kliendiauto
WHERE last_name LIKE 'S%'
ORDER BY car_year DESC
LIMIT 10;

SELECT * FROM kliendiauto 
WHERE car_make IN ('Audi', 'Dodge') 
AND car_price > 1000;

SELECT AVG(car_price) as 'avarage price', sum(car_price) AS 'sum price'
from kliendiauto

create table autorent (
    id INT PRIMARY KEY,
    date_time DATE,
    full_name VARCHAR(50),
    email VARCHAR(50),
    auto_hind VARCHAR(50),
    cliendiAutoID INT,
    FOREIGN KEY (cliendiAutoID) REFERENCES kliendiauto(id)
);

insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (1, '2023-12-15', 'Grady Londesborough', 'glondesborough0@wisc.edu', '€186,66', 1);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (2, '2023-04-20', 'Janot Guisot', 'jguisot1@yahoo.com', '€184,86', 2);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (3, '2024-02-20', 'Jonell Wagon', 'jwagon2@earthlink.net', '€172,30', 3);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (4, '2023-06-18', 'Osbert Clelle', 'oclelle3@csmonitor.com', '€496,20', 4);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (5, '2023-08-11', 'Isabella Waud', 'iwaud4@list-manage.com', '€454,47', 5);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (6, '2023-12-19', 'Anthe Hawkeridge', 'ahawkeridge5@slideshare.net', '€363,07', 6);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (7, '2024-02-15', 'Katlin de Castelain', 'kde6@netlog.com', '€360,55', 7);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (8, '2023-12-05', 'Marilin Holleran', 'mholleran7@cam.ac.uk', '€372,00', 8);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (9, '2023-10-22', 'Kettie Fairtlough', 'kfairtlough8@nyu.edu', '€468,41', 9);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (10, '2023-06-04', 'Minda Abrahamowitcz', 'mabrahamowitcz9@dagondesign.com', '€309,32', 10);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (11, '2024-03-29', 'Wanids Breckell', 'wbreckella@gizmodo.com', '€497,93', 11);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (12, '2023-04-30', 'Britni Rolin', 'brolinb@cam.ac.uk', '€174,75', 12);
insert into autorent (id, date_time, full_name, email, auto_hind, cliendiAutoID) values (13, '2024-02-08', 'Violetta Grinaugh', 'vgrinaughc@ca.gov', '€236,54', 13);