Write a SQL query to select the county with the most votes for Republican in each state. The resulting table may look like: CountyID Name State Alabama Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois 1073 Jefferson 4013 Maricopa 5119 Pulaski 6037 Los Angeles 8041 El Paso 9001 Fairfield 10003 New Castle 11001 District of Columbia 12086 Miami-Dade 13067 Cobb 15003 Honolulu 16001 Ada 17031 Cook Total Population Percent White Percent Black Percent_Asian Percent_Hispanic 658552 51 42 1 3889161 58 3 30 386106 55 2 6 9893481 28 48 634423 72 15 926233 66 17 542784 61 619371 35 10 2549075 16 65 699235 56 12 964678 19 401673 86 7 5212372 44 24 2550 35 8 6 10 23 74514688 25 49 25 2 14 3 5 5 24 3 336 43