RANDOM andmete lisamine andmebaasi

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, 'Johannah', 'Halt', 'jhalt0@washingtonpost.com', 'BMW', '5 Series', 2001, 4927.73);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, 'Heida', 'Coniff', 'hconiff1@nyu.edu', 'Hyundai', 'XG300', 2001, 6998.35);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, 'Ebba', 'Cremen', 'ecremen2@washington.edu', 'Subaru', 'Justy', 1994, 5635.58);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, 'Vivia', 'Woolhouse', 'vwoolhouse3@posterous.com', 'Ford', 'Mustang', 2012, 9259.25);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (5, 'Minnie', 'Lafont', 'mlafont4@state.gov', 'Chevrolet', 'Malibu', 2006, 7350.93);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (6, 'Nicki', 'Whenman', 'nwhenman5@diigo.com', 'Infiniti', 'G35', 2003, 7291.4);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (7, 'Belle', 'Cornelius', 'bcornelius6@tumblr.com', 'GMC', 'Rally Wagon G3500', 1995, 4594.69);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (8, 'Fulton', 'Brandassi', 'fbrandassi7@google.com.hk', 'Volkswagen', 'GTI', 1989, 3637.62);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (9, 'Keeley', 'Marnane', 'kmarnane8@dropbox.com', 'Chevrolet', 'Avalanche 1500', 2002, 2203.94);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (10, 'Kayla', 'Kinsey', 'kkinsey9@google.com.br', 'Dodge', 'Dakota Club', 1997, 8907.13);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (11, 'Bendicty', 'Gosenell', 'bgosenella@webmd.com', 'Mitsubishi', 'Expo', 1995, 7819.59);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (12, 'Marieann', 'Tinwell', 'mtinwellb@mlb.com', 'Mercury', 'Mountaineer', 2001, 9032.72);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (13, 'Mathilda', 'Ayce', 'maycec@usnews.com', 'BMW', 'Z4', 2011, 6223.95);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (14, 'Dex', 'Skarin', 'dskarind@biblegateway.com', 'Subaru', 'Impreza', 2005, 4977.58);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (15, 'Dredi', 'Detloff', 'ddetloffe@purevolume.com', 'Audi', 'TT', 2001, 427.46);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (16, 'Dorothy', 'Scardafield', 'dscardafieldf@qq.com', 'Toyota', 'Supra', 1992, 2869.04);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (17, 'Emalee', 'Murrish', 'emurrishg@wikimedia.org', 'Porsche', '968', 1993, 7700.89);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (18, 'Cori', 'Hollows', 'chollowsh@aboutads.info', 'Infiniti', 'QX', 2002, 9518.68);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (19, 'Demetris', 'Longstreet', 'dlongstreeti@moonfruit.com', 'Nissan', 'Titan', 2008, 880.96);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (20, 'Winna', 'Walshe', 'wwalshej@studiopress.com', 'Subaru', 'Impreza', 2002, 1573.01);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (21, 'Harlie', 'Eagles', 'heaglesk@elpais.com', 'Subaru', 'Outback', 2000, 1588.58);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (22, 'Hannah', 'Worcester', 'hworcesterl@usa.gov', 'Jeep', 'Wrangler', 2009, 3559.33);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (23, 'Duffy', 'Tyrone', 'dtyronem@hubpages.com', 'Mercedes-Benz', 'G55 AMG', 2006, 6078.02);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (24, 'Carolin', 'Crank', 'ccrankn@mysql.com', 'Chevrolet', 'Astro', 2002, 2286.46);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (25, 'Itch', 'Di Biagio', 'idibiagioo@toplist.cz', 'Maserati', 'Quattroporte', 2006, 1758.71);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (26, 'Vivie', 'Crawford', 'vcrawfordp@unesco.org', 'Mercedes-Benz', 'M-Class', 2003, 4873.27);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (27, 'Mariya', 'Finlason', 'mfinlasonq@yahoo.com', 'Buick', 'Skylark', 1993, 9133.35);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (28, 'Berry', 'Abbiss', 'babbissr@taobao.com', 'Land Rover', 'Discovery', 2010, 4845.13);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (29, 'Trumann', 'Beloe', 'tbeloes@123-reg.co.uk', 'Land Rover', 'Range Rover', 2010, 5201.52);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (30, 'Inglebert', 'Rouch', 'iroucht@weebly.com', 'Volvo', 'V70', 2003, 1521.78);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (31, 'Bridget', 'Gopsill', 'bgopsillu@digg.com', 'Oldsmobile', 'Toronado', 1966, 6338.48);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (32, 'Hyacintha', 'Scadden', 'hscaddenv@mtv.com', 'Chevrolet', 'Impala', 2011, 4997.95);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (33, 'Franny', 'Taw', 'ftaww@ocn.ne.jp', 'BMW', 'X3', 2011, 6774.35);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (34, 'Brittan', 'Bonnaire', 'bbonnairex@ovh.net', 'Aston Martin', 'Vanquish S', 2005, 4959.06);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (35, 'Ahmed', 'Thaller', 'athallery@purevolume.com', 'Chevrolet', 'Lumina', 1995, 6095.1);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (36, 'Nicky', 'Gibbens', 'ngibbensz@businessweek.com', 'Porsche', 'Boxster', 1999, 9764.04);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (37, 'Mortie', 'Kerridge', 'mkerridge10@oaic.gov.au', 'Pontiac', 'Solstice', 2008, 2578.2);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (38, 'Nate', 'Wallington', 'nwallington11@blogger.com', 'Kia', 'Rio', 2011, 8382.77);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (39, 'Analiese', 'Cockett', 'acockett12@squidoo.com', 'Mercedes-Benz', 'SL-Class', 2009, 8216.3);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (40, 'Mike', 'Reach', 'mreach13@sogou.com', 'Dodge', 'Ram 1500', 2010, 9095.4);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (41, 'Onida', 'Bellany', 'obellany14@dropbox.com', 'GMC', 'Envoy', 2003, 1278.38);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (42, 'Kristi', 'Weinham', 'kweinham15@phpbb.com', 'Jeep', 'Cherokee', 1992, 4296.41);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (43, 'Shellie', 'Grimwad', 'sgrimwad16@parallels.com', 'Toyota', 'Yaris', 2012, 788.54);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (44, 'Ermina', 'Dooney', 'edooney17@businessweek.com', 'Ford', 'Ranger', 2004, 7321.36);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (45, 'Marlowe', 'Poat', 'mpoat18@t-online.de', 'Nissan', 'Pathfinder', 1995, 8713.89);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (46, 'Torrie', 'Stayte', 'tstayte19@bloglovin.com', 'Chevrolet', 'G-Series G20', 1995, 3622.92);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (47, 'Jarrett', 'Renachowski', 'jrenachowski1a@wix.com', 'Mitsubishi', 'Montero', 1993, 1143.82);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (48, 'Marlowe', 'Crisp', 'mcrisp1b@miibeian.gov.cn', 'Porsche', 'Cayman', 2012, 3615.45);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (49, 'Alli', 'Rubenov', 'arubenov1c@microsoft.com', 'GMC', 'Envoy', 2002, 7234.43);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (50, 'Shermy', 'Cheek', 'scheek1d@histats.com', 'Chevrolet', 'Cruze', 2012, 2607.55);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (51, 'Jessa', 'Lampe', 'jlampe1e@1und1.de', 'Maserati', 'Gran Sport', 2006, 7414.92);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (52, 'Isaak', 'Jorden', 'ijorden1f@booking.com', 'Dodge', 'Colt', 1994, 6017.31);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (53, 'Dicky', 'Bellino', 'dbellino1g@scribd.com', 'Volkswagen', 'Passat', 1991, 8130.88);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (54, 'Gilly', 'Lukacs', 'glukacs1h@comcast.net', 'Toyota', 'Avalon', 2011, 5810.22);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (55, 'Kerrill', 'Emberton', 'kemberton1i@intel.com', 'Mercury', 'Villager', 1998, 9876.23);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (56, 'Junie', 'Paulack', 'jpaulack1j@wsj.com', 'Toyota', 'RAV4', 2010, 9465.93);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (57, 'Bria', 'Downgate', 'bdowngate1k@samsung.com', 'Lincoln', 'LS', 2004, 8292.65);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (58, 'Yorker', 'Cratere', 'ycratere1l@disqus.com', 'Land Rover', 'Range Rover', 1995, 3847.95);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (59, 'Olympie', 'Lovie', 'olovie1m@phoca.cz', 'Volvo', '960', 1995, 8608.75);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (60, 'Chevalier', 'Alvares', 'calvares1n@ovh.net', 'Saturn', 'VUE', 2008, 9803.63);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (61, 'Victor', 'Gillam', 'vgillam1o@xinhuanet.com', 'BMW', 'Z3', 1997, 111.21);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (62, 'Orelie', 'Trumble', 'otrumble1p@discovery.com', 'Suzuki', 'Kizashi', 2012, 4079.3);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (63, 'Ilyse', 'Gantley', 'igantley1q@yahoo.com', 'BMW', 'X3', 2012, 3663.75);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (64, 'Ansel', 'Long', 'along1r@digg.com', 'Ford', 'Transit Connect', 2010, 6731.66);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (65, 'Kevin', 'Streater', 'kstreater1s@cnn.com', 'Lincoln', 'Navigator', 2009, 8291.85);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (66, 'Alikee', 'Uzielli', 'auzielli1t@sciencedaily.com', 'Pontiac', 'Firebird', 1990, 2999.9);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (67, 'Angelita', 'McCree', 'amccree1u@chron.com', 'Hyundai', 'Accent', 1995, 8589.2);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (68, 'Terrence', 'Hazelhurst', 'thazelhurst1v@gov.uk', 'Bentley', 'Continental Flying Spur', 2006, 6613.39);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (69, 'Fee', 'MacCrosson', 'fmaccrosson1w@cbslocal.com', 'Ford', 'Edge', 2011, 6635.21);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (70, 'Daryn', 'Heaysman', 'dheaysman1x@hubpages.com', 'Dodge', 'Grand Caravan', 1996, 5577.14);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (71, 'Hayes', 'Nassy', 'hnassy1y@senate.gov', 'Kia', 'Borrego', 2009, 1086.75);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (72, 'Shaylyn', 'Yelland', 'syelland1z@deliciousdays.com', 'Audi', 'Quattro', 1985, 9161.17);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (73, 'Matias', 'Hundy', 'mhundy20@admin.ch', 'Toyota', 'Supra', 1996, 5781.02);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (74, 'Demott', 'Zannotelli', 'dzannotelli21@businessweek.com', 'Volvo', 'S40', 2011, 8633.79);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (75, 'Aharon', 'Meikle', 'ameikle22@wordpress.org', 'Maybach', '57', 2008, 4350.26);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (76, 'Pollyanna', 'Hirjak', 'phirjak23@ted.com', 'GMC', 'Yukon XL 1500', 2007, 6811.31);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (77, 'Rory', 'Kitchin', 'rkitchin24@bravesites.com', 'Lexus', 'GX', 2011, 6707.27);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (78, 'Eugine', 'Cornock', 'ecornock25@imdb.com', 'Toyota', 'Land Cruiser', 2010, 6176.64);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (79, 'Greg', 'Kix', 'gkix26@netlog.com', 'Infiniti', 'QX', 2007, 7495.81);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (80, 'Tracie', 'Egarr', 'tegarr27@reference.com', 'Land Rover', 'Defender', 1992, 3833.33);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (81, 'Idaline', 'Brett', 'ibrett28@nps.gov', 'Toyota', 'Previa', 1991, 4724.23);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (82, 'Butch', 'Sussams', 'bsussams29@nsw.gov.au', 'Pontiac', 'Bonneville', 1992, 6046.08);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (83, 'Zelma', 'Nathon', 'znathon2a@opera.com', 'MG', 'MGB', 1977, 4088.68);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (84, 'Carver', 'Diben', 'cdiben2b@gmpg.org', 'Ford', 'Ranger', 1997, 108.43);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (85, 'Berton', 'Lillyman', 'blillyman2c@go.com', 'Rambler', 'Classic', 1963, 945.23);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (86, 'Angelle', 'Duckers', 'aduckers2d@engadget.com', 'Ford', 'Contour', 1996, 7066.51);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (87, 'Zerk', 'Batie', 'zbatie2e@tinypic.com', 'Chevrolet', 'Camaro', 1968, 5551.83);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (88, 'Leopold', 'Baldung', 'lbaldung2f@desdev.cn', 'Audi', 'Q7', 2009, 8913.63);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (89, 'Allissa', 'Pitkeathley', 'apitkeathley2g@zdnet.com', 'Buick', 'Lucerne', 2009, 8021.46);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (90, 'Felizio', 'Turl', 'fturl2h@youtu.be', 'Oldsmobile', 'Aurora', 1998, 3309.21);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (91, 'Land', 'Masic', 'lmasic2i@vimeo.com', 'Ford', 'E-Series', 1993, 9105.49);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (92, 'Gusty', 'Syers', 'gsyers2j@fda.gov', 'Toyota', 'Celica', 1992, 1018.29);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (93, 'Kerry', 'Georgelin', 'kgeorgelin2k@narod.ru', 'Pontiac', 'Tempest', 1966, 2638.61);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (94, 'Sanson', 'Hotton', 'shotton2l@go.com', 'Nissan', 'Maxima', 2007, 2949.62);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (95, 'Rhianna', 'Geaveny', 'rgeaveny2m@marriott.com', 'Mazda', 'RX-7', 1988, 886.43);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (96, 'Charissa', 'McCrossan', 'cmccrossan2n@msn.com', 'Lexus', 'CT', 2012, 7561.62);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (97, 'Doralyn', 'Schusterl', 'dschusterl2o@eepurl.com', 'Lexus', 'SC', 2003, 2131.05);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (98, 'Jobyna', 'McGrey', 'jmcgrey2p@ebay.co.uk', 'Mitsubishi', 'Cordia', 1988, 6020.19);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (99, 'Jena', 'McVanamy', 'jmcvanamy2q@qq.com', 'GMC', 'Vandura G2500', 1995, 1931.01);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (100, 'Karim', 'Sheldrake', 'ksheldrake2r@vkontakte.ru', 'Audi', 'A3', 2008, 570.15);

UPDATE kliendiauto 
SET car_make='Zaporožets'
WHERE id>100;

SELECT * from kliendiauto
WHERE id>100;

UPDATE kliendiauto
SET car_make='Citroën'
WHERE car_make='Toyota';
--kontrollimiseks näidata ei Toyota puudub tabelis
SELECT * FROM kliendiauto
WHERE car_make='Toyota'

DELETE FROM kliendiauto
WHERE id=5 or id=10 or id=15;
SELECT * FROM kliendiauto
WHERE id=5 AND id=10 AND id=15;

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

SELECT last_name,car_make,car_year FROM kliendiauto
WHERE last_name like 'O%'
ORDER by car_year DESC
LIMIT 10;

SELECT * FROM kliendiauto
Where car_make='Subaru' AND car_price>5000 or car_make='Maserati' AND car_price>5000
----------
WHERE car_make IN (Subaru,Maseritu) AND car_price>5000

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

create table Muuk (
	id INT PRIMARY KEY,
	kuupäev DATE,
	muukHind DECIMAL(7,2),
	phone VARCHAR(50),
	kliediAutoID INT,
	FOREIGN KEY(kliediAutoID) REFERENCES kliendiautoid(id)
);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (1, '2024-01-11', 1875.86, '283 905 1647', 1);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (2, '2023-10-29', 3239.83, '314 112 0171', 2);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (3, '2023-08-15', 1254.94, '444 385 1017', 3);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (4, '2023-04-30', 9951.59, '359 693 7799', 4);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (6, '2023-11-17', 3733.92, '532 836 4898', 6);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (7, '2023-11-09', 6764.04, '784 670 0922', 7);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (8, '2023-04-21', 6175.78, '443 995 8031', 8);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (9, '2023-07-01', 4306.69, '304 676 5491', 9);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (11, '2023-10-18', 8556.75, '303 580 0860', 11);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (12, '2023-08-26', 7048.76, '470 557 9676', 12);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (13, '2024-02-08', 3855.15, '566 785 2234', 13);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (14, '2023-05-18', 3180.83, '183 502 1950', 14);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (16, '2024-03-27', 1735.41, '671 480 4561', 16);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (17, '2023-07-02', 8997.85, '472 691 6794', 17);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (18, '2023-08-26', 9576.41, '297 451 8455', 18);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (19, '2023-11-06', 1734.1, '569 354 1380', 19);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (20, '2024-01-11', 5709.05, '483 340 8972', 20);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (21, '2023-10-25', 6794.33, '379 528 3487', 21);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (22, '2024-03-18', 4174.95, '403 698 6991', 22);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (23, '2024-02-29', 8790.32, '134 364 3065', 23);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (24, '2023-09-23', 7085.21, '111 972 3434', 24);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (25, '2023-10-11', 5001.2, '632 963 0325', 25);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (26, '2024-02-26', 9575.05, '975 520 9969', 26);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (27, '2024-03-06', 6742.2, '405 883 0994', 27);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (28, '2024-02-14', 5468.97, '141 821 1693', 28);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (29, '2023-10-02', 1702.94, '833 819 2962', 29);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (30, '2023-04-20', 9811.76, '873 503 1938', 30);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (31, '2024-03-25', 2910.78, '790 121 2365', 31);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (32, '2023-09-11', 6651.27, '872 172 7330', 32);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (33, '2023-11-23', 8289.49, '759 529 4877', 33);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (34, '2023-10-24', 9126.57, '242 842 9878', 34);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (35, '2023-10-19', 8644.23, '763 282 1378', 35);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (36, '2023-11-25', 9227.47, '541 551 0357', 36);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (37, '2023-06-13', 4165.94, '165 990 9324', 37);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (38, '2023-04-22', 8934.63, '101 356 5007', 38);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (39, '2023-07-12', 9443.07, '853 489 0832', 39);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (40, '2024-02-02', 5876.49, '414 656 4382', 40);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (41, '2024-01-03', 2468.48, '309 143 3822', 41);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (42, '2024-03-26', 8058.47, '758 211 7192', 42);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (43, '2023-11-28', 6647.42, '417 840 7995', 43);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (44, '2023-08-22', 1496.6, '178 871 7898', 44);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (45, '2023-11-23', 2871.42, '931 493 6994', 45);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (46, '2023-11-11', 8418.03, '486 719 2883', 46);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (47, '2023-06-08', 1078.37, '924 462 8294', 47);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (48, '2024-04-05', 3676.78, '116 301 8950', 48);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (49, '2023-08-24', 8534.36, '842 773 7983', 49);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (50, '2024-03-20', 5482.77, '295 845 3380', 50);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (51, '2023-08-10', 2511.14, '268 541 5069', 51);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (52, '2023-11-12', 8623.51, '496 820 0267', 52);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (53, '2023-09-03', 6244.17, '889 634 1174', 53);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (54, '2023-04-27', 6743.79, '299 973 4666', 54);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (55, '2024-03-14', 1646.11, '552 812 2924', 55);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (56, '2023-09-12', 3079.33, '278 390 8830', 56);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (57, '2024-04-07', 1088.28, '317 706 1055', 57);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (58, '2023-09-08', 5383.66, '550 783 7090', 58);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (59, '2023-05-03', 8058.76, '531 537 2784', 59);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (60, '2023-09-18', 5683.27, '302 689 5638', 60);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (61, '2023-12-18', 1593.76, '202 839 8155', 61);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (62, '2023-09-06', 1513.64, '753 558 8650', 62);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (63, '2023-06-14', 6719.72, '599 886 5968', 63);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (64, '2023-11-16', 7132.1, '414 246 3460', 64);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (65, '2024-01-04', 3621.58, '255 437 8962', 65);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (66, '2023-12-18', 1046.54, '181 103 3752', 66);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (67, '2023-11-11', 3756.35, '104 195 2433', 67);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (68, '2024-01-27', 2992.3, '543 335 3624', 68);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (69, '2023-08-30', 6567.72, '923 240 9388', 69);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (70, '2023-09-11', 9991.17, '626 165 9339', 70);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (71, '2024-01-30', 3483.29, '826 948 5645', 71);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (72, '2023-08-28', 4771.92, '357 174 4137', 72);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (73, '2023-11-22', 1153.99, '495 650 0661', 73);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (74, '2024-02-22', 3991.31, '547 385 1565', 74);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (75, '2023-11-12', 5857.22, '635 785 4927', 75);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (76, '2023-08-05', 5496.5, '236 983 3630', 76);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (77, '2023-06-20', 8698.19, '979 509 0786', 77);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (78, '2023-11-06', 7693.04, '888 822 0293', 78);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (79, '2023-07-27', 3388.2, '678 933 3571', 79);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (80, '2024-01-13', 9851.95, '444 554 1834', 80);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (81, '2024-01-07', 1127.81, '512 249 6781', 81);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (82, '2024-02-10', 3946.59, '384 367 0620', 82);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (83, '2023-07-29', 5218.67, '780 186 3935', 83);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (84, '2023-11-27', 2161.01, '906 234 0493', 84);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (85, '2023-12-15', 6617.37, '594 992 1034', 85);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (86, '2023-11-21', 6315.03, '548 392 2234', 86);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (87, '2023-06-06', 8238.91, '899 451 1142', 87);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (88, '2023-07-15', 1301.43, '854 568 7788', 88);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (89, '2023-12-20', 3958.61, '327 512 9190', 89);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (90, '2023-04-13', 9635.1, '435 764 7915', 90);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (91, '2023-07-31', 8726.81, '570 652 1949', 91);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (92, '2023-08-26', 1859.62, '751 437 1968', 92);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (93, '2023-04-27', 2548.75, '397 222 3585', 93);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (94, '2023-06-19', 4952.51, '308 701 3061', 94);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (95, '2023-08-30', 5171.51, '131 299 7638', 95);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (96, '2024-03-10', 8799.96, '993 380 6600', 96);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (97, '2024-01-09', 8392.39, '356 850 8086', 97);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (98, '2023-12-18', 5177.37, '988 615 1810', 98);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (99, '2023-10-03', 3082.09, '984 328 2267', 99);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (100, '2024-02-23', 5484.68, '272 445 0150', 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 (11, 'Jelizaveta', 'Ostapjuk', 'jelizaveta.ostapjuk@gmail.com', 'Toyota', 'Yaris', 2008, 6855);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (12, 'Polina', 'Judina', 'polka@gmail.com', 'Honda', 'Civic', 2012, 4050);
insert into KliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (13, 'Raul', 'Adamson', 'rauletta@gmail.com', 'Porshe', '911', 2024, 9780);

UPDATE kliendiauto 
SET car_make='Zaporožets'
WHERE id>100;

UPDATE kliendiauto
SET car_make='Citroën'
WHERE car_make='Ford';

DELETE FROM kliendiauto
WHERE id=5 or id=7 or id=9;

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

SELECT last_name,car_make,car_year FROM kliendiauto
WHERE last_name like 'O*'
ORDER by car_year DESC
LIMIT 10;

SELECT * FROM kliendiauto
Where car_make='Subaru' AND car_price>5000 or car_make='Zaporozets' AND car_price>5000

create table Muuk (
	id INT PRIMARY KEY,
	kuupäev DATE,
	muukHind INT,
	phone VARCHAR(50),
	kliediAutoID INT,
	FOREIGN KEY(kliediAutoID) REFERENCES kliendiauto(id)
);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (1, '2024-01-11', 1875.86, '283 905 1647', 1);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (2, '2023-10-29', 3239.83, '314 112 0171', 2);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (3, '2023-08-15', 1254.94, '444 385 1017', 3);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (4, '2023-04-30', 9951.59, '359 693 7799', 4);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (6, '2023-11-17', 3733.92, '532 836 4898', 6);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (8, '2023-04-21', 6175.78, '443 995 8031', 8);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (10, '2023-06-05', 1348.88, '706 771 2628', 10);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (11, '2023-10-18', 8556.75, '303 580 0860', 11);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (12, '2023-08-26', 7048.76, '470 557 9676', 12);
insert into Muuk (id, kuupäev, muukHind, phone, kliediAutoID) values (13, '2024-02-08', 3855.15, '566 785 2234', 13);