1. Display, in each state, the number of agents sorted in the descending order.
2. Display the number of agents in each branch and the sum of their salaries.
3. In each branch, display the number of agents living in New Jersey (NJ) or New York (NY) states and the average of their salaries.
4. Exclude, from the list you displayed in the previous task, the branches that have salary averages less than $34000.

AGENTNO FNAME LNAME BRANCHNO SALARY DOB ADDRESS CITY COUNTY STATE ZIP PHONE1 PHONE EMAIL A011 Minna Anigon B002 33600 e1-SEP-81 2371 Jerrold Ave 19443 215-874-1229 ninna_amigon@yahoo.com Kulpsville Columbia Montgomery Richland 1953 Sabra Uyetake B002 33000 26-JUL-73 98839 Hanthorne Blvd 45101 SC 29201 8e3-925-5213 823-681-3678 sabra@uyetake.org A083 Arlette Honeywell 8802 24000 29-JUL-85 Jacksonville Duval FL 32254 904-775-4480 11279 Loytan st 1747 Calle Amanecer #2 2 1994 Wilda Giguere B882 36888 82-APR-88 Anchorage Anchorage 99501 987-878-5536 A102 Louisa Cronauer 3882 43882 23-MAR-93 524 Louisiana Ave NW San Leandro Alameda 94577 512-828-7847 904-514-9918 ahoneywell@honeywell.com 987-914-9482 wilda@cox.net 518-472-7758 louisa cronauer.com 305-575-8481 panella.schmierer@schmierer.org 9e9-589-1693 lindsey.dilello@hotnoil.com becky.nirafuentes@nirafuentes.com A115 Pamella Schmierer B002 31200 21. JUL-55 5161 Dorsett Rd Homestead Miami-Dade FL 33232 305.420.5970 A123 Lindsey Dilello Beez 38000 es-MAR-57 52777 Leaders Heights Rd Ontario San Bernardino 91761 909-639-9887 A135 Becky Mirafuentes B282 41400 28-JAN-91 38553 Washington Rd Plainfield union NO e7262 988-877-5489 A142 Sheridan Zane Beez 32482 19-MAY-71 2489 Alabana Rd Riverside Riverside CA 92581 951-645-360 sheridan. Zane@zane.com A167 Fannie Lungren Bee2 31282 25-JUL-85 17 US Highway 111 Round ROCK williamson TX 78664 512-587-5746 A181 Marguerita Hiatt B002 45688 81-JAN-91 32 N Highway 67 Oakley Contra Costa CA 94561 925-634.7155 512-528-9933 fannie. lungren@yahoo.com 925-541-5521 marguerita.hiatt@gmail.com benton.skursky@aol.com A195 Benton skursky B002 49089 23-APR-SS 47939 Porter Ave Gardena LOS Angeles CA 90248 312-579-2907 A202 Helga Fredicks BeB2 32002 29-MAR-93 42754 S Ash Ave Buffalo Erie NY 14228 716-752-4114 A208 Aliza Bee2 46800 14-FEB-62 1128 Delaware st San Jose Santa Clara CA 95132 488-524-3552 4e8-425-1994 aliza@aol.com Baltinore Frankel Tiera 19200 24. FEB.56 87 Sierra Rd El Monte LOS Angeles 91731 626-636-4117 626-629-4241 tfrankel@aol.com A231 Justine Mugnolo Bee2 2788 New York New York NY 18048 jmugnolo@yahoo.com A233 Chaya Malvin B002 16-AUG-62 38862 E Main St E 06-AUG-74 560 Civic Center Dr sce 27-NOV-65 33 Leni Rd #46 Ann Arbor Washtenau MI 48103 734-928-5192 734.408-8174 chaya@nolvin.com A257 Deandrea Hughey 3802 30000 Burlington Alamance NC 27215 336-822-7652 deandrea@yahoo.com A262 Charlene Hanilton B002 36889 16-APR-64 985 6th Ave Santa Rosa Sonoma 95407 707-320-1771 787-821-8937 Charlene.hanilton@hotmail.com A285 Lavonda Hengel B002 45000 01-MAY-65 87 Imperial ct 179 Fargo Cass ND 58102 701-898-2154 781-421-7880 layonda@cox.net A288 Casie Good B002 28269 28-NOV-71 5221 Bear Valley Rd Nashville Davidson TN 37211 615-390-2251 615-825-4297 casie.good@aol.com A293 Raul Upthegrove B002 32489 28-JUN-60 La Hesa San Diego 91942 619-509-5282 4 E Colonial Dr 206 Main St #2904 A305 Ligia Reiber B002 56489 15-MAY-83 Lansing Inghan MI 48933 517-906-1105 517-747-7664 lreiber@cox.net A314 Kattie Vonasek B002 43200 19-JUL-91 2845 Boulder Crescent st Cleveland Cuy shoga OH 44103 216-923-3715 kattic@vonasek.org 4326 Adelina Nabours 8882 32489 20-AUG-92 80 Pittsford Victor Rd #9 Cleveland Cuyahoga OH 44103 216-230.4892 216-937-5320 A337 Dulce Labreche B802 41402 11-JAN-79 9581 E Arapahoe Rd Rochester Oakland MI 48207 249-257-8715 A349 Samira Heintzman B002 43200 3-AUG-80 8772 Old County Rd 45410 Kent King WA 98032 206-311-4137 A354 Denise Bee2 34200 13-NOV-89 2139 Santa Rosa Ave Orlando Orange FL 32801 407-446-4358 243-811-5696 dulce_labreche@yahoo.com 206-923-5042 sheintzman@hotmail.com 487-588-3254 denise@patak.org 586-247-1614 markus@yahoo.com gschnitzler@gmail.com A377 Markus Lukasik Bee2 31200 12-FEB-80 89 zeth St E *779 Sterling Heights Macomb MI 48310 586-978-7388 A380 Gayla Schnitzler B002 3eee e8-NOV-89 38 Pleasant Hill Rd Alameda CA 94545 Hayward Parkville 4896 Annelle Tagala 3882 41489 16-DEC-96 5 W 7th St Baltimore 21234 418-757-1835 418-234-2267 annelle@yahoo.com A419 Merissa Tomblin 3992 27882 27-AUG-92 34 Raritan Center Pky Bellflower Los Angeles CA 90706 merissa. tomblin@gmail.com 973-644-2974 Shonda_greenbush@cox.net A442 Shonda Greenbush BOO2 28208 el-JUN-84 82 US Highway 46 Clifton Passaic NO 27811 973-482-2430 A453 cristal Samara Beez 42000 27-NOV-83 4119 Metropolitan Dr Los Angeles CA 98821 213-975-se2s LOS Angeles Inghan A454 Kenneth Grenet Bee2 29482 14-APR-82 2167 Sierra Rd East Lansing MI 48823 517-499-2322 517-867-8077 kenneth.grenet@grenet.org A458 NU Mcnease Bee2 31280 82-JUL-85 39 Su 28th Ter Harrison Hudson NO 07829 973-751-9023 973-903-4175 nu@gmail.com A462 Nan Koppinger Bee2 21-JAN-G7 88827 Frankford Ave Greensboro Guilford NC 27481 336.370.5333 336-564-1492 nanakoppinger.com 4477 Glory Schieler B002 26469 03-FEB-92 S E Truman Rd Abilene Taylor TX 79602 325-869-2649 glory@yahoo.com A487 Dorothy Chesterfield 2002 31289 15-JAN-67 469 outwater in San Diego San Diego CA 92126 859-617-7834 dorothy@cox.net A220 Fletcher Flosi B005 60000 17-SEP-81 394 Manchester Blvd Rockford Winnebago IL 61109 fletcher.flosi@yahoo.com A829 Willow Kusko 3885 48200 87-NOV-95 90991 Thorburn Ave New York New York NY 18011 212-582-4976 212-934-5167 wkusko@yahoo.com A036 Solange Shinko B285 43200 01-SEP-93 426 Wolf st Metairie Jefferson LA 78802 584-979-9175 A856 Tonette Wenner Bees 51000 03-DEC-78 4545 Courthouse Rd Westbury Nassau NY 11590 516-968-6051 A272 Johnetta Abdallah B005 26400 82-MAR-69 1888 Pinehurst st Chapel Hill Orange NC 27514 919-225-9345 919-715-3791 A091 Tammara Wardrip B005 45000 25-NOV-77 4800 Black Horse Pike Burlingame San Mateo CA 94010 650-803-1936 twenner@aol.com johnetta_abdallah@aol.com twardrip@cox.net bulah_padilla@hotmail.com nelida@gmail.com A143 Bulah Padilla B285 58400 15-SEP-75 8927 Vandever Ave Waco McLennan TX 76707 254-463-4368 254-816-8417 A180 Nelida Sawchuk B005 48800 14-APR-64 3 State Route 35 S Paramus Bergen NJ 87652 201-971-1638