Group by практика

create table customers ( id integer constraint customers_pk primary key autoincrement, name varchar(255), address varchar(255), country varchar (255) ); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Olaf Nienow', '5323 Bernier Turnpike East Orvillestad, MN 04663', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Dr. Adela Herman III', '97864 Crystel Keys New Toney, IL 39353', 'China'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Ms. Sydnie Leuschke IV', '52224 Weimann Glen Suite 724 North Daniella, KS 61143-0545', 'India'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Leann Kautzer', '4679 Wehner Flats Suite 726 New Jasmin, WI 23920-1086', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Olaf Robel', '153 Eloy Row Hoegerfort, UT 80971', 'Belarus'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Emmett Ortiz', '518 Serena Turnpike Suite 914 South Bayleeland, OH 06046-7948', 'India'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Yasmine Krajcik', '5617 Luigi Shores Suite 392 New Grant, AL 96933-1250', 'China'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Adolph Hill', '8310 Lenny Mews Suite 350 Port Dorcasborough, WY 78691', 'China'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Will Von DVM', '43930 Dante Pass Lake Justenbury, ND 71516', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Ms. Savannah Hamill', '8583 Bartoletti Land Suite 195 West Ernestomouth, MI 55906-7726', 'Belarus'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Maeve Gusikowski DVM', '5282 Christopher Village Suite 089 Port Lenoraberg, AR 87209', 'Belarus'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Mr. Wilhelm Toy', '90543 Rachael Estates Curtborough, WI 11356', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Kaylah Champlin', '462 Cletus Manor Port Mathias, TX 28447-9175', 'India'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Wilmer Nienow', '536 Jackson Square South Jacky, TX 65817', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Luigi Barrows', '36491 Gaylord Groves Suite 431 Lake Edytheview, CT 98519-6764', 'India'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Amber Lang PhD', '168 Block Mews South Misael, MA 27625-7317', 'India'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Madelyn Crist', '228 Harvey Oval Suite 370 Connmouth, MT 82958', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Omari Dibbert', '92458 Alva Passage Suite 498 West Norvaltown, TN 83413-1282', 'Belarus'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Althea Lebsack', '939 Dominique Locks Apt. 884 Jacobsonfurt, IL 07525-4139', 'USA'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Dr. Hattie Rutherford', '675 Labadie Locks East Orionfort, DC 17971-6987', 'China'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Janiya Mann', '69276 Dicki Course Luellaview, KS 50138-7037', 'China'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Lilian Kihn', '25314 Loma Gardens Apt. 451 Wolffport, NV 99428', 'USA'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Elissa Mertz', '310 Sarai Avenue Apt. 633 Velvatown, IN 51314-6172', 'USA'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Barney Cremin DVM', '511 Pouros Oval Suite 469 Hudsonchester, HI 91128-0795', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Jana Labadie', '93043 Kuhic Pines Suite 040 Lake Ronaldo, IA 73558', 'USA'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Elinore Haag', '6322 Amari Spur Suite 400 Karleyview, IA 11407-4280', 'USA'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Prof. Oren Wilkinson DVM', '6178 Elmore Track Langstad, AL 13827', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Everette Kertzmann', '97427 Mueller Stream Hegmannville, ID 49196-4346', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Mr. Eino Larson', '363 Braun Lane Suite 978 Osinskihaven, RI 28186-3733', 'USA'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Miss Rosetta Kulas', '2132 Bobby Union Moenbury, GA 95516', 'Belarus'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Letha Lueilwitz', '39319 Amalia Mount New Devyn, NC 71894', 'USA'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Dr. Katlynn Farrell', '6728 Howe Locks Apt. 698 Kellenport, AL 44618', 'India'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Yolanda Fahey', '4180 Parisian Parkway Suite 406 West Kayberg, VA 30586', 'USA'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Kaden Reynolds', '13048 Feil Turnpike Suite 353 Gianniside, AL 97441-5315', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Amara Mills Jr.', '59884 Alycia Drives Tamaraland, ND 89510', 'Belarus'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Ashleigh Champlin', '182 Fadel Meadow Larkinmouth, SC 60322', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Barton Luettgen', '6671 Bradtke Estates Apt. 184 Lake Aliya, DC 32626-4704', 'China'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Alf Jacobson', '50396 Ashton Garden South Omaville, IL 25814-0864', 'China'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Soledad Abshire', '5206 Block Vista Apt. 366 Beahantown, AL 43215-9776', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Ms. Maximillia Medhurst', '30501 Naomi Locks Apt. 411 South Ramonamouth, SD 55496', 'India'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Hassan Schiller', '5422 Monahan Harbor Suite 404 Port Mistymouth, AK 48821-4348', 'Belarus'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Mrs. Caroline Emmerich', '34112 Treutel Street Carmelafort, MD 69118-8174', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Dr. Dejah Gerlach', '23585 Isidro Centers Norvalbury, FL 83748', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Myrtice Jacobson IV', '791 Nader Radial Suite 393 Lindgrenhaven, AL 45667', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Dr. Hattie Wisozk Jr.', '5189 Turner Forges East Anne, ME 25641-1024', 'China'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Dr. Jimmie Sipes', '835 Wilkinson Burg Apt. 606 Lake Rahsaanland, DE 58552', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Ms. Lila Leffler', '8194 Daniel Trail Suite 492 Port Maynard, NJ 92549', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Dr. Cristopher Wyman', '7937 Araceli Club Suite 046 Leonchester, RI 70915-6648', 'Germany'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Shane Douglas Sr.', '64338 Samson Mall Vonburgh, AZ 09412-9585', 'Russia'); INSERT INTO customers (`name`, `address`, `country`) VALUES ('Chad Heaney', '360 Marjolaine Radial Lakinside, VT 82342', 'Germany');