Random database - Vsevolod Tsarev portfoolio || Eng

RANDOM andmed – https://www.mockaroo.com

XAMPP Localhost

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 DECIMAL(7,2)
);

insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (1, 'Danila', 'Berardt', 'dberardt0@wikispaces.com', 'GMC', 'Jimmy', 1993, 8478.47);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, 'Gordan', 'Tomadoni', 'gtomadoni1@nyu.edu', 'Jeep', 'Compass', 2009, 4604.55);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, 'Delila', 'Jurkiewicz', 'djurkiewicz2@plala.or.jp', 'GMC', '2500', 1993, 2675.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, 'Colline', 'Jermin', 'cjermin3@mlb.com', 'Mercedes-Benz', 'CL-Class', 2010, 8349.29);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (5, 'Edd', 'Perdue', 'eperdue4@senate.gov', 'Kia', 'Rio', 2002, 2437.18);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (6, 'Faythe', 'Ghiron', 'fghiron5@ft.com', 'Mazda', 'Tribute', 2011, 4157.19);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (7, 'Tammy', 'Arbon', 'tarbon6@ycombinator.com', 'Infiniti', 'I', 1996, 6575.49);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (8, 'Ginger', 'Rolf', 'grolf7@salon.com', 'Nissan', 'Pathfinder', 2002, 6601.07);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (9, 'Gabriel', 'Mullinger', 'gmullinger8@utexas.edu', 'GMC', 'Savana 1500', 2007, 4543.4);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (10, 'Lamont', 'Dorwood', 'ldorwood9@ftc.gov', 'Pontiac', 'Montana', 2005, 9388.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (11, 'Valentine', 'Beeston', 'vbeestona@sakura.ne.jp', 'Mazda', 'B-Series Plus', 2003, 5162.67);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (12, 'Noe', 'Brockman', 'nbrockmanb@over-blog.com', 'BMW', '5 Series', 2007, 1746.2);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (13, 'Ruben', 'Enden', 'rendenc@canalblog.com', 'Subaru', 'Justy', 1993, 7953.14);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (14, 'Shari', 'Prandy', 'sprandyd@boston.com', 'Chevrolet', 'Corvette', 1960, 1471.29);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (15, 'Orin', 'Wittrington', 'owittringtone@bing.com', 'GMC', 'Canyon', 2008, 7280.44);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (16, 'Humbert', 'Bullimore', 'hbullimoref@blogs.com', 'GMC', 'Safari', 2004, 5020.72);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (17, 'Rinaldo', 'Saur', 'rsaurg@elpais.com', 'Chevrolet', 'Corsica', 1995, 355.4);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (18, 'Lorilee', 'Rigney', 'lrigneyh@bloomberg.com', 'Dodge', 'Caravan', 2006, 4012.99);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (19, 'Arther', 'Luard', 'aluardi@joomla.org', 'Lincoln', 'Continental', 2000, 9349.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (20, 'Rochella', 'Buxey', 'rbuxeyj@vimeo.com', 'Chevrolet', 'Colorado', 2010, 7762.05);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (21, 'Gaylord', 'Bangle', 'gbanglek@symantec.com', 'Chevrolet', 'SSR', 2004, 6229.89);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (22, 'Ronica', 'Storry', 'rstorryl@deliciousdays.com', 'Suzuki', 'Grand Vitara', 2003, 7115.91);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (23, 'Lia', 'Lacotte', 'llacottem@youku.com', 'Mercury', 'Grand Marquis', 1993, 885.42);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (24, 'Sabra', 'Stuart', 'sstuartn@people.com.cn', 'Geo', 'Tracker', 1996, 912.22);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (25, 'Francine', 'Pateman', 'fpatemano@squarespace.com', 'Buick', 'Skylark', 1985, 168.67);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (26, 'Haily', 'Stidson', 'hstidsonp@examiner.com', 'Dodge', 'D150 Club', 1992, 9191.2);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (27, 'Lethia', 'Moss', 'lmossq@drupal.org', 'Pontiac', 'Grand Am', 1995, 1451.33);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (28, 'Erhart', 'Bakewell', 'ebakewellr@guardian.co.uk', 'Infiniti', 'FX', 2005, 6197.56);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (29, 'Dilan', 'MacVagh', 'dmacvaghs@phoca.cz', 'Oldsmobile', 'Alero', 2003, 9035.51);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (30, 'Shaun', 'Rieger', 'sriegert@printfriendly.com', 'Ford', 'Fusion', 2009, 3517.31);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (31, 'Vernor', 'Unwin', 'vunwinu@usda.gov', 'Dodge', 'Grand Caravan', 1995, 5367.49);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (32, 'Frederick', 'Murra', 'fmurrav@github.io', 'Lincoln', 'LS', 2003, 912.86);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (33, 'Duky', 'Enbury', 'denburyw@woothemes.com', 'GMC', 'Yukon', 1997, 8592.97);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (34, 'Nigel', 'Peak', 'npeakx@google.co.jp', 'Isuzu', 'i-280', 2006, 5819.45);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (35, 'Shanna', 'Toretta', 'storettay@bluehost.com', 'Isuzu', 'Trooper', 1995, 415.14);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (36, 'Trisha', 'Snary', 'tsnaryz@taobao.com', 'Ford', 'Taurus', 2006, 5892.22);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (37, 'Gaston', 'Pietranek', 'gpietranek10@merriam-webster.com', 'Buick', 'Riviera', 1987, 1734.09);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (38, 'Loria', 'Fasham', 'lfasham11@sbwire.com', 'Chevrolet', 'Express 2500', 1999, 1585.22);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (39, 'Emmit', 'Illes', 'eilles12@imageshack.us', 'Toyota', 'RAV4', 2008, 6057.99);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (40, 'Davin', 'Keenleyside', 'dkeenleyside13@miibeian.gov.cn', 'BMW', '6 Series', 2004, 8903.53);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (41, 'Dyana', 'Adnet', 'dadnet14@economist.com', 'Mitsubishi', 'Galant', 2007, 4941.94);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (42, 'Appolonia', 'Celle', 'acelle15@cafepress.com', 'Pontiac', 'Grand Am', 1988, 3285.23);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (43, 'Trish', 'Twentyman', 'ttwentyman16@instagram.com', 'Saturn', 'Astra', 2008, 1573.02);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (44, 'Lance', 'Tomasino', 'ltomasino17@fotki.com', 'Chrysler', 'Town & Country', 1996, 1248.42);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (45, 'Richie', 'Stanbury', 'rstanbury18@java.com', 'Volkswagen', 'Touareg', 2004, 223.82);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (46, 'Mufinella', 'Mortlock', 'mmortlock19@aol.com', 'Buick', 'Rainier', 2006, 6158.6);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (47, 'Guenevere', 'Priel', 'gpriel1a@archive.org', 'Oldsmobile', 'Intrigue', 2001, 2438.09);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (48, 'Stormie', 'Michelmore', 'smichelmore1b@fda.gov', 'Land Rover', 'Range Rover', 2006, 9599.21);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (49, 'Katharyn', 'Guerrier', 'kguerrier1c@360.cn', 'Volvo', 'C70', 2000, 1751.87);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (50, 'Devonna', 'Danigel', 'ddanigel1d@tamu.edu', 'Land Rover', 'Range Rover Sport', 2012, 6996.91);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (51, 'Daryl', 'Ismail', 'dismail1e@vimeo.com', 'Pontiac', 'Bonneville', 2004, 7722.74);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (52, 'Sara-ann', 'Bellenie', 'sbellenie1f@princeton.edu', 'Isuzu', 'Hombre', 2000, 5265.94);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (53, 'Lesli', 'Dark', 'ldark1g@guardian.co.uk', 'Ford', 'Bronco', 1987, 6910.58);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (54, 'Cazzie', 'Blaine', 'cblaine1h@oakley.com', 'Suzuki', 'Equator', 2010, 3414.74);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (55, 'Courtney', 'Gorden', 'cgorden1i@blog.com', 'GMC', 'Savana 3500', 2004, 2980.63);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (56, 'Vilhelmina', 'MacAnelley', 'vmacanelley1j@arstechnica.com', 'Mercury', 'Mystique', 2000, 5035.47);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (57, 'Elonore', 'Keyson', 'ekeyson1k@php.net', 'Buick', 'Skyhawk', 1984, 6825.28);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (58, 'Marian', 'Hatton', 'mhatton1l@samsung.com', 'Ford', 'Econoline E150', 1993, 529.34);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (59, 'Neall', 'Eble', 'neble1m@ox.ac.uk', 'GMC', 'Safari', 2004, 5362.41);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (60, 'Dulciana', 'Chandlar', 'dchandlar1n@sohu.com', 'Cadillac', 'Escalade', 2012, 6473.96);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (61, 'Vinnie', 'Tille', 'vtille1o@msn.com', 'Dodge', 'Aries', 1981, 6410.73);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (62, 'Kile', 'Lever', 'klever1p@fc2.com', 'Pontiac', 'Grand Am', 1989, 4080.57);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (63, 'Dorothy', 'Sandever', 'dsandever1q@weibo.com', 'Kia', 'Soul', 2012, 2058.05);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (64, 'Desirae', 'Glanders', 'dglanders1r@usnews.com', 'Isuzu', 'Hombre', 2000, 3146.76);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (65, 'Ekaterina', 'Faherty', 'efaherty1s@indiatimes.com', 'Chevrolet', 'Corvette', 2008, 1213.15);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (66, 'Jaymie', 'Lewens', 'jlewens1t@google.es', 'Chevrolet', 'Camaro', 1974, 3974.81);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (67, 'Saidee', 'Deery', 'sdeery1u@home.pl', 'Nissan', 'Armada', 2009, 7853.96);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (68, 'Lucretia', 'Vasyagin', 'lvasyagin1v@yale.edu', 'Buick', 'Riviera', 1998, 4199.7);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (69, 'Kristoffer', 'Ovendon', 'kovendon1w@angelfire.com', 'Volkswagen', 'GTI', 2002, 3024.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (70, 'Cyndie', 'Nother', 'cnother1x@hhs.gov', 'Pontiac', 'Parisienne', 1985, 2420.91);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (71, 'Kath', 'Dunford', 'kdunford1y@google.co.jp', 'Toyota', 'Solara', 2004, 4659.72);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (72, 'Raymond', 'Woolcocks', 'rwoolcocks1z@youku.com', 'Porsche', 'Boxster', 2013, 3498.84);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (73, 'Phaedra', 'Bark', 'pbark20@mtv.com', 'Honda', 'Accord', 1988, 2837.37);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (74, 'Adella', 'Moorhouse', 'amoorhouse21@vinaora.com', 'Mercedes-Benz', 'SL-Class', 2007, 4448.95);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (75, 'Patric', 'Turmel', 'pturmel22@webnode.com', 'Dodge', 'Viper', 1999, 4898.23);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (76, 'Cami', 'Bartelli', 'cbartelli23@gravatar.com', 'Toyota', 'Prius', 2007, 7796.61);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (77, 'Janean', 'Enga', 'jenga24@forbes.com', 'Mercury', 'Grand Marquis', 2006, 8901.25);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (78, 'Coleman', 'Kidder', 'ckidder25@sitemeter.com', 'Chevrolet', 'Lumina', 1997, 6394.56);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (79, 'Teodoro', 'Whitefoot', 'twhitefoot26@abc.net.au', 'Saab', '9000', 1998, 6763.71);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (80, 'Mohammed', 'Dingivan', 'mdingivan27@webnode.com', 'Toyota', 'Corolla', 2002, 4197.65);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (81, 'Natty', 'Trayling', 'ntrayling28@hubpages.com', 'Mercedes-Benz', 'Sprinter 3500', 2012, 8531.1);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (82, 'Claudelle', 'Knightsbridge', 'cknightsbridge29@shareasale.com', 'Chevrolet', 'Venture', 2003, 7413.63);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (83, 'Lodovico', 'Pettengell', 'lpettengell2a@npr.org', 'Isuzu', 'Ascender', 2004, 1587.29);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (84, 'Giffer', 'Rosendahl', 'grosendahl2b@virginia.edu', 'Buick', 'Century', 1990, 337.89);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (85, 'Baxie', 'Moehler', 'bmoehler2c@booking.com', 'Saturn', 'S-Series', 2001, 4530.76);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (86, 'Janina', 'Clee', 'jclee2d@simplemachines.org', 'Nissan', 'Sentra', 2005, 2993.17);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (87, 'Sarita', 'Perotti', 'sperotti2e@gravatar.com', 'Honda', 'Accord', 2004, 8635.8);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (88, 'Gisele', 'D''Aeth', 'gdaeth2f@gizmodo.com', 'Subaru', 'Outback', 2004, 4880.23);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (89, 'Halli', 'Murcutt', 'hmurcutt2g@weather.com', 'Dodge', 'Ram 2500', 2004, 7208.57);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (90, 'Terra', 'Fraine', 'tfraine2h@delicious.com', 'Dodge', 'Ram Wagon B150', 1992, 3479.75);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (91, 'Stanton', 'Hymans', 'shymans2i@sfgate.com', 'Chevrolet', 'Venture', 2005, 514.19);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (92, 'Carny', 'McGarrahan', 'cmcgarrahan2j@opensource.org', 'Ford', 'Thunderbird', 1987, 9231.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (93, 'Gran', 'Thairs', 'gthairs2k@slideshare.net', 'Honda', 'Accord', 2010, 3309.97);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (94, 'Shay', 'Duffield', 'sduffield2l@chron.com', 'Plymouth', 'Voyager', 1996, 4315.15);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (95, 'Klara', 'Karpol', 'kkarpol2m@ebay.com', 'Dodge', 'Ram', 1994, 1086.74);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (96, 'Grissel', 'Farrans', 'gfarrans2n@uiuc.edu', 'Ford', 'Thunderbird', 1958, 4533.51);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (97, 'Fielding', 'Brito', 'fbrito2o@blinklist.com', 'Jeep', 'Grand Cherokee', 2011, 1243.54);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (98, 'Bernadette', 'Whimper', 'bwhimper2p@vimeo.com', 'Pontiac', 'Bonneville', 1964, 1949.6);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (99, 'Benjamen', 'Dunk', 'bdunk2q@gnu.org', 'Dodge', 'Daytona', 1993, 5413.75);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (100, 'Melisent', 'Villa', 'mvilla2r@photobucket.com', 'Mitsubishi', 'Pajero', 1986, 7718.39);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (101, 'Vsevolod', 'Tsarev', 'tsarev@tthk.ee', 'Bugatti', 'Divo', 2018, 1253.26);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (102, 'Bogdan', 'Sergachev', 'sergachev@tthk.ee', 'BMW', 'M4 Competition', 2023, 2521.45);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (103, 'Kirill', 'Sats', 'sats@tthk.ee', 'BMW', 'E60', 2012, 6119.19);

SELECT, UPDATE, DELETE lausete kasutamine

Muuda enda lisatud automargiks Zaporožets

UPDATE kliendiauto
SET car_make='Zaporozec'
WHERE id>100;

SELECT * FROM kliendiauto
WHERE id>100;

Muuda kõik Cadillac margid Citroën’iks

SELECT * FROM kliendiauto
WHERE car_make LIKE 'Cadillac';

UPDATE kliendiauto
SET car_make='Citroën'
WHERE car_make LIKE 'Cadillac';

--kontrollimiseks nädata ei Cadillac puudub tabelis
SELECT * FROM kliendiauto
WHERE car_make LIKE 'Cadillac';

Kustuta ära read, mille ID on 5, 10 ja 15

SELECT * FROM kliendiauto
where id&lt;16; 
delete from kliendiauto
WHERE id=5 or id=10 or id=15;
SELECT * FROM kliendiauto
where id&lt;16;

Kuva read, kus on ainult ID, perenimi, automark ja aasta, sorteeri ID järgi kasvavalt

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

Kuva 10 rida autosid, kus kliendi perenimi hakkab sama algustähega, mis sul, sorteeri autod aasta järgi kahanevalt

--perenimi algab 'T'
SELECT last_name, car_make, car_year
FROM kliendiauto
WHERE LEFT (last_name,1)='T'
ORDER BY car_year DESC
LIMIT 10;
--perenimi algab 'T'
SELECT last_name, car_make, car_year
FROM kliendiauto
WHERE last_name LIKE 'T%'
ORDER BY car_year DESC
LIMIT 10;

Kuva 2 vabalt valitud automarki sisaldavad read ja ületavad mingit summat

SELECT last_name, car_make, car_price
FROM kliendiauto
WHERE car_make IN ('BMW', 'Mercedes') AND car_price >=6000;

Keskmine autode hind ja summarne autode hind

SELECT AVG(car_price) AS 'average price', SUM(car_price) AS 'sum price'
FROM kliendiauto;

CREATE TABLE muuk(
    muukID INT PRIMARY KEY,
	kuupaev DATE,
	muuja VARCHAR(50),
	muugihind VARCHAR(50),
	kliendiAutoid INT,
    FOREIGN KEY(kliendiAutoid) REFERENCES kliendiAuto(id)
    );

insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (1, '2023-12-17', 'Carlin Mayoh', '€3169,15', 1);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (2, '2023-12-08', 'Victor Heball', '€8515,78', 2);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (3, '2023-10-01', 'Fiorenze Nerne', '€7519,16', 3);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (4, '2023-08-04', 'Karyl Shirland', '€9162,34', 4);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (5, '2023-07-03', 'Stormi Garfath', '€12499,95', 1);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (6, '2023-12-26', 'Imogen Rowlinson', '€8591,88', 6);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (7, '2023-07-19', 'Jarrad Joseph', '€2349,00', 7);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (8, '2023-10-05', 'Vi Leathard', '€12293,57', 8);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (9, '2023-10-30', 'Jerrie Slyvester', '€11874,87', 9);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (10, '2023-08-02', 'Pablo Pell', '€4519,89', 1);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (11, '2024-03-01', 'Tallia Gowry', '€2566,75', 11);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (12, '2024-03-16', 'Cathryn Kinastan', '€7703,25', 12);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (13, '2023-12-04', 'Tedd Wherrett', '€2182,77', 13);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (14, '2024-04-06', 'Dode Eliot', '€10674,00', 14);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (15, '2023-04-10', 'Emmalynne Skelhorn', '€4583,37', 1);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (16, '2023-06-08', 'Teodorico Bradie', '€1464,28', 16);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (17, '2023-08-30', 'Jasmin Mulvagh', '€11822,63', 17);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (18, '2023-10-22', 'Pascale Filpo', '€6727,20', 18);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (19, '2024-04-01', 'Jenna Constantine', '€8549,38', 19);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (20, '2024-01-20', 'Renee O''Kennavain', '€12912,46', 20);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (21, '2024-02-27', 'Adolf Lared', '€12200,28', 21);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (22, '2023-07-04', 'Tally Ansill', '€5756,65', 22);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (23, '2023-06-07', 'Duffy Diddams', '€8382,07', 23);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (24, '2023-07-24', 'Corilla Henze', '€7675,79', 24);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (25, '2024-03-14', 'Alfredo Jerche', '€2588,87', 25);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (26, '2023-11-18', 'Hadrian Parry', '€3986,96', 26);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (27, '2023-11-08', 'Tyrone Kobus', '€4088,14', 27);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (28, '2023-11-06', 'Garold Gourlay', '€3673,18', 28);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (29, '2023-12-17', 'Clementius Fearnsides', '€11597,93', 29);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (30, '2023-08-31', 'Bobette Greeno', '€5991,41', 30);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (31, '2023-09-05', 'Frasquito Cowlam', '€10058,85', 31);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (32, '2023-12-17', 'Clarke McMurrugh', '€3343,64', 32);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (33, '2023-06-02', 'Anjela Alred', '€14605,24', 33);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (34, '2023-04-11', 'Klaus Jermey', '€5610,85', 34);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (35, '2024-01-28', 'Barrie Piotr', '€14477,50', 35);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (36, '2023-10-15', 'Rees Di Domenico', '€9643,34', 36);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (37, '2023-06-25', 'Cecilia Monaghan', '€2618,73', 37);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (38, '2023-05-26', 'Danette Fairholme', '€11380,32', 38);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (39, '2023-12-01', 'Kelbee Letty', '€4870,44', 39);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (40, '2023-09-15', 'Kristyn Neve', '€1457,28', 40);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (41, '2023-12-10', 'Wyn Rosendale', '€6425,37', 41);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (42, '2024-02-13', 'Sander Tackett', '€13435,96', 42);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (43, '2023-10-22', 'Rosana Routham', '€8356,05', 43);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (44, '2024-02-24', 'Casie Dumbarton', '€6057,97', 44);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (45, '2024-04-03', 'Rickert Birchwood', '€10953,03', 45);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (46, '2023-09-14', 'Jody Cullity', '€1243,16', 46);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (47, '2023-11-30', 'Hynda Dunsleve', '€10649,67', 47);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (48, '2024-02-03', 'Teddie Rene', '€1833,88', 48);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (49, '2023-08-06', 'Archer Early', '€12503,09', 49);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (50, '2023-12-19', 'Blinnie Bourne', '€8297,09', 50);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (51, '2023-07-30', 'Carlotta Lapides', '€10001,81', 51);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (52, '2023-09-07', 'Hammad Foale', '€5689,76', 52);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (53, '2023-11-28', 'Daryl Attewell', '€11798,25', 53);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (54, '2023-06-06', 'Spike Scapens', '€5040,07', 54);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (55, '2023-06-13', 'Amby Higgonet', '€12536,01', 55);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (56, '2023-06-03', 'Lisetta Dax', '€5898,42', 56);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (57, '2023-08-05', 'Had Catchpole', '€13677,33', 57);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (58, '2024-03-09', 'Kippy Sturton', '€3324,52', 58);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (59, '2024-03-09', 'Isidor Hark', '€8721,30', 59);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (60, '2024-01-29', 'Bernhard Wenger', '€7091,92', 60);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (61, '2023-06-29', 'Alika Tremaine', '€9614,61', 61);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (62, '2023-07-05', 'Talya Rennels', '€12386,47', 62);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (63, '2023-08-31', 'Krissy Boumphrey', '€6141,50', 63);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (64, '2023-10-13', 'Maitilde Rassell', '€6144,51', 64);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (65, '2024-01-20', 'Talyah Ormistone', '€14110,40', 65);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (66, '2024-04-07', 'Melanie Scarre', '€4245,91', 66);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (67, '2023-06-27', 'Petronella Luker', '€5866,48', 67);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (68, '2023-10-12', 'Calida Arnout', '€10562,52', 68);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (69, '2024-03-11', 'Lesly Pearton', '€5346,05', 69);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (70, '2023-11-29', 'Donny Gudgion', '€5643,18', 70);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (71, '2023-06-08', 'Berty Di Roberto', '€10965,98', 71);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (72, '2023-09-03', 'Broddie Strelitzer', '€4618,53', 72);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (73, '2023-10-24', 'Aloisia Paradyce', '€7487,20', 73);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (74, '2023-12-26', 'Diahann Bosson', '€14910,68', 74);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (75, '2023-10-24', 'Diann Loughlin', '€12311,46', 75);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (76, '2023-07-21', 'Valerie Blackley', '€12115,15', 76);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (77, '2023-08-31', 'Morse Hindsberg', '€6494,86', 77);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (78, '2023-11-20', 'Westleigh Seiler', '€13544,08', 78);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (79, '2023-12-29', 'Jodie Antcliff', '€12065,44', 79);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (80, '2024-04-08', 'Arel Adamou', '€12792,81', 80);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (81, '2024-02-01', 'Wileen Sieve', '€8179,13', 81);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (82, '2023-08-17', 'Fredelia Mulhall', '€10110,91', 82);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (83, '2023-11-21', 'Paulette Broadbridge', '€3973,90', 83);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (84, '2023-08-17', 'Blanca Audus', '€14808,50', 84);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (85, '2023-12-24', 'Virginie Matelaitis', '€2456,51', 85);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (86, '2024-02-20', 'Fidela Dickson', '€1878,03', 86);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (87, '2024-03-13', 'Jesse Gerritzen', '€8623,44', 87);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (88, '2023-04-24', 'Lari Conklin', '€4456,96', 88);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (89, '2023-11-23', 'Marissa Rosson', '€2265,89', 89);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (90, '2023-11-24', 'Selle Hurkett', '€5972,79', 90);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (91, '2024-03-21', 'Corrinne Simmgen', '€5502,03', 91);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (92, '2023-11-28', 'Ad Heake', '€4745,41', 92);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (93, '2023-08-20', 'Meredithe Leak', '€14680,47', 93);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (94, '2023-11-22', 'Baryram Waddell', '€9385,19', 94);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (95, '2023-05-18', 'Cullan Birdis', '€12107,37', 95);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (96, '2023-12-31', 'Val Vermer', '€7531,04', 96);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (97, '2023-08-01', 'Chrysa Belcham', '€9590,22', 97);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (98, '2023-04-19', 'Bridgette Warry', '€10205,57', 98);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (99, '2023-09-06', 'Loren Cockren', '€13557,16', 99);
insert into muuk (muukID, kuupaev, muuja, muugihind, kliendiAutoid) values (100, '2023-10-04', 'Jaime Gotmann', '€11896,10', 100);

MS ACCESS

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, 'Danila', 'Berardt', 'dberardt0@wikispaces.com', 'GMC', 'Jimmy', 1993, 8478.47);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, 'Gordan', 'Tomadoni', 'gtomadoni1@nyu.edu', 'Jeep', 'Compass', 2009, 4604.55);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, 'Delila', 'Jurkiewicz', 'djurkiewicz2@plala.or.jp', 'GMC', '2500', 1993, 2675.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, 'Colline', 'Jermin', 'cjermin3@mlb.com', 'Mercedes-Benz', 'CL-Class', 2010, 8349.29);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (5, 'Edd', 'Perdue', 'eperdue4@senate.gov', 'Kia', 'Rio', 2002, 2437.18);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (6, 'Faythe', 'Ghiron', 'fghiron5@ft.com', 'Mazda', 'Tribute', 2011, 4157.19);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (7, 'Tammy', 'Arbon', 'tarbon6@ycombinator.com', 'Infiniti', 'I', 1996, 6575.49);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (8, 'Ginger', 'Rolf', 'grolf7@salon.com', 'Nissan', 'Pathfinder', 2002, 6601.07);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (9, 'Gabriel', 'Mullinger', 'gmullinger8@utexas.edu', 'GMC', 'Savana 1500', 2007, 4543.4);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (10, 'Lamont', 'Dorwood', 'ldorwood9@ftc.gov', 'Pontiac', 'Montana', 2005, 9388.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (11, 'Valentine', 'Beeston', 'vbeestona@sakura.ne.jp', 'Mazda', 'B-Series Plus', 2003, 5162.67);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (12, 'Noe', 'Brockman', 'nbrockmanb@over-blog.com', 'BMW', '5 Series', 2007, 1746.2);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (13, 'Ruben', 'Enden', 'rendenc@canalblog.com', 'Subaru', 'Justy', 1993, 7953.14);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (14, 'Shari', 'Prandy', 'sprandyd@boston.com', 'Chevrolet', 'Corvette', 1960, 1471.29);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (15, 'Orin', 'Wittrington', 'owittringtone@bing.com', 'GMC', 'Canyon', 2008, 7280.44);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (16, 'Humbert', 'Bullimore', 'hbullimoref@blogs.com', 'GMC', 'Safari', 2004, 5020.72);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (17, 'Rinaldo', 'Saur', 'rsaurg@elpais.com', 'Chevrolet', 'Corsica', 1995, 355.4);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (18, 'Lorilee', 'Rigney', 'lrigneyh@bloomberg.com', 'Dodge', 'Caravan', 2006, 4012.99);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (19, 'Arther', 'Luard', 'aluardi@joomla.org', 'Lincoln', 'Continental', 2000, 9349.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (20, 'Rochella', 'Buxey', 'rbuxeyj@vimeo.com', 'Chevrolet', 'Colorado', 2010, 7762.05);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (21, 'Gaylord', 'Bangle', 'gbanglek@symantec.com', 'Chevrolet', 'SSR', 2004, 6229.89);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (22, 'Ronica', 'Storry', 'rstorryl@deliciousdays.com', 'Suzuki', 'Grand Vitara', 2003, 7115.91);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (23, 'Lia', 'Lacotte', 'llacottem@youku.com', 'Mercury', 'Grand Marquis', 1993, 885.42);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (24, 'Sabra', 'Stuart', 'sstuartn@people.com.cn', 'Geo', 'Tracker', 1996, 912.22);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (25, 'Francine', 'Pateman', 'fpatemano@squarespace.com', 'Buick', 'Skylark', 1985, 168.67);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (26, 'Vsevolod', 'Tsarev', 'tsarev@tthk.ee', 'Bugatti', 'Divo', 2018, 1253.26);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (27, 'Bogdan', 'Sergachev', 'sergachev@tthk.ee', 'BMW', 'M4 Competition', 2023, 2521.45);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (28, 'Kirill', 'Sats', 'sats@tthk.ee', 'BMW', 'E60', 2012, 6119.19);