> -- Find the names of candidates who ran for an office ending in '19A' > -- CANDIDATE_NAME ---------------------------------------------- TERRY MORROW > -- > -- > -- Provide an alphabetical list of the parties' full names. > -- PARTY_NAME --------------------------- Constitution Party Constitutional Government Democratic-Farmer-Labor Ecology Democracy Party Grassroots Party Green Party Independence Independent Justice Party Libertarian Party Minnesota Open Progressives Nonpartisan Republican Socialism and Liberation Socialist Workers Party Write-In 16 rows selected > -- > -- > -- Find the candidates who ran for the office of 'U.S. Senator'. > -- For each, list the candidate's and party's full names. > -- Hint: join tables using the party abbreviation, not the party ID. > -- Later you will see why. > -- CANDIDATE_NAME PARTY_NAME ---------------------------------------------- --------------------------- STEPHEN WILLIAMS Independence KURT BILLS Republican AMY KLOBUCHAR Democratic-Farmer-Labor TIM DAVIS Grassroots Party MICHAEL CAVLAN Minnesota Open Progressives > -- > -- > -- Find a list of candidates' names for those candidates for US office > -- who received a majority of the votes in at least one precinct > -- in 'Nicollet' county. > -- CANDIDATE_NAME ---------------------------------------------- ALLEN QUIST AMY KLOBUCHAR BARACK OBAMA AND JOE BIDEN MITT ROMNEY AND PAUL RYAN TIM WALZ > -- > -- > -- In which precinct (or precincts) did 'TERRY MORROW' receive his largest > -- vote count? Give your answer as a precinct name (or names, if there is > -- a tie). > -- PRECINCT_NAME ------------------------------------ ST PETER W-1 P-2 > -- > -- > -- In which counties did 'TERRY MORROW' have election results? > -- Give your result as an alphabetic list of county names. > -- COUNTY_NAME ----------------- Blue Earth Le Sueur Nicollet > -- > -- > -- In how many precincts did 'TIM WALZ' have results? > -- COUNT(*) -------- 695 > -- > -- > -- > -- In how many precincts did 'TIM WALZ' receive a majority of the votes? > -- COUNT(*) -------- 498 > -- > -- > -- Find any rows of the candidates table that contain a party ID number > -- not present in the table of parties. For each, show the candidate's > -- name and party ID number. > -- CANDIDATE_NAME PARTY_ID ---------------------------------------------- -------- ANTHONY HILTON 100 PETA LINDSAY AND YARI OSORIO 104 ROSS C. "ROCKY" ANDERSON AND LUIS J. RODRIGUEZ 105 DEAN MORSTAD AND JOSH FRANKE-HYLAND 103 JIM CARLSON AND GEORGE MCMAHON 102 TIM DAVIS 102 MICHAEL CAVLAN 101 7 rows selected > -- > -- > -- Find any candidates with a party ID that does not match the one > -- shown in the parties table for the candidate's party abbreviation. > -- For each, show the candidate's name, candidate ID, party ID number, > -- party abbreviation, and the party ID number that is listed in the parties > -- table as corresponding to the abbreviation. > -- CANDIDATE_NAME CANDIDATE_ID PARTY_ID PARTY_ABBREVIATION PARTY_ID ---------------------------------------------- ------------ -------- ------------------ -------- JERRY "PIKE" PAGEL 2191301 8 IND 13 PAUL BERGLEY 2500701 10 CP 7 TIM UTZ 2690701 10 CP 7 ANTHONY HILTON 3051201 100 EDP 12 PETA LINDSAY AND YARI OSORIO 1011401 104 SL 14 VIRGIL GOODE AND JIM CLYMER 1010701 10 CP 7 ROSS C. "ROCKY" ANDERSON AND LUIS J. RODRIGUEZ 1011501 105 JP 15 JILL STEIN AND CHERI HONKALA 1010901 7 GP 9 GARY JOHNSON AND JIM GRAY 1010501 11 LIB 5 DEAN MORSTAD AND JOSH FRANKE-HYLAND 1010801 103 CG 8 JIM CARLSON AND GEORGE MCMAHON 1011001 102 GR 10 TIM DAVIS 1021001 102 GR 10 MICHAEL CAVLAN 1021101 101 MOP 11 SCOTT LARSON 1841301 8 IND 13 14 rows selected > -- > -- > -- Find any counties where the number of precincts shown in the > -- counties table doesn't match how many are in the precincts table. > -- no rows selected > -- > -- > -- Produce a table of state-wide votes for the US Senate race, showing in each > -- row the candidate's name and the corresponding number of votes. The table > -- should be in descending order of votes. > -- CANDIDATE_NAME VOTES ---------------- ----- AMY KLOBUCHAR 1854595 KURT BILLS 867974 STEPHEN WILLIAMS 73539 TIM DAVIS 30531 MICHAEL CAVLAN 13986 WRITE-IN** 2582 6 rows selected > -- > -- > -- What percentage of 'YES' votes did 'Constitutional Amendment 1' receive > -- in each county? List the county names with their percentages (which should > -- be labeled as such). Give the list in ascending order of percentage. > -- > -- Hint 1: The PERCENTAGE column in the AMENDMENT_RESULTS table is not > -- helpful for this. > -- Hint 2: The TOTAL_VOTES column in the AMENDMENT_RESULTS table is the total > -- over all "candidates" for the same "office" in the same precinct. > -- COUNTY_NAME PERCENTAGE ----------------- ---------- Hennepin 34.72415065820693533929732674833471009016 Ramsey 36.45191243169886789757508660404985536231 Cook 39.90427759497457373616512114866886030512 St. Louis 44.11595150618218738437975925177033410485 Dakota 44.58675740917472395075376450419093927996 Washington 44.73119335559359129044024804287437919134 Blue Earth 45.83466326204915416533673795084583466326 Rice 46.30572265926268702761067407064630572266 Nicollet 46.98423020647049260282880832384978052349 Winona 47.02361400051096755356034891784371692398 Scott 48.92934065170569026610157715556173139721 Olmsted 48.96353630482581563528679096605279546523 Carver 50.02354980312364588632039036153657755421 Clay 50.46844860843207495177734913199228437586 Anoka 50.61335756474329850068150840527033166742 Lake 50.99927060539752005835156819839533187454 Beltrami 51.07936364865473883455766370724232727928 Carlton 51.93852790509571313022377999460771097331 Goodhue 52.39748485900551633684372950661574663426 Stearns 53.02308491498365557610926690824316448319 Koochiching 53.79183297513048817930610991710162726435 Benton 55.39357124778537079220450518855985826373 Steele 55.57000208029956313709174121073434574579 Stevens 55.65722329755410874538096076016188632764 Itasca 55.66084788029925187032418952618453865337 Wright 56.02836879432624113475177304964539007092 Sherburne 56.32011646827096000685107476235334418087 Fillmore 56.60515256714781655399232596382240087703 Mower 56.77643908969210174029451137884872824632 Chisago 56.84968557711812833863006288457637433227 Le Sueur 57.57433068747477465357190905421767792278 Houston 57.6780450698868498621279832651896928782 Dodge 58.62102125204346571785748629675930377921 Wabasha 59.17953912382881742213218536338313497088 Crow Wing 59.75418484615165255083126586249180140873 Waseca 59.78028684772657918828196521208422337504 Freeborn 60.04043527383005292263780698103109948267 Mille Lacs 60.73298429319371727748691099476439790576 Swift 60.90253375254299981505455890512298871833 Isanti 60.99133687733805867296711951171490450876 Mahnomen 61.36363636363636363636363636363636363636 Pennington 61.40484534511656254761541977754075879933 Aitkin 61.81798459702787721010955635101420978414 Hubbard 61.85433884297520661157024793388429752066 Cass 61.93942384800444142865955215594349515761 Lyon 61.99341946874247652676350212663510151673 Pine 62.14777485981971751011427354673859038967 Kandiyohi 62.76338995637241251276338995637241251276 Becker 62.9227126464695525469006131989557403922 Norman 63.0187519213034122348601291115893021826 Chippewa 63.12419974391805377720870678617157490397 Pope 63.50039777247414478918058870326173428799 Watonwan 63.62232091137285190191156593937053485229 Douglas 63.63550251018281708818793217770199867387 Grant 63.86434881732687375320604160729552579082 Lake Of The Woods 63.90743213173119715175789942145082331998 Meeker 64.47079847291040532856794736414588579319 Kanabec 64.4968246213971665852467024914509037616 Polk 64.58530645379515627114057637667433364903 Faribault 64.93372796293913267275768884313473169476 Yellow Medicine 65.46920821114369501466275659824046920821 Mcleod 65.69973190348525469168900804289544235925 Traverse 66.23863028357410379882289994649545211343 Renville 66.28446276732800824529760371038392166967 Brown 66.37205987170349251603706343549536707056 Kittson 66.43556280587275693311582381729200652529 Otter Tail 66.53054813884089838228365007067692790953 Big Stone 67.04545454545454545454545454545454545455 Martin 67.62387897454479572425038499864118126642 Lac Qui Parle 67.65660094834040429248814574494634389818 Red Lake 67.66467065868263473053892215568862275449 Morrison 67.85056720318346498782443428164162261686 Wilkin 68.58024691358024691358024691358024691358 Sibley 68.68327402135231316725978647686832740214 Jackson 68.83069649027095835606473904346244771777 Redwood 69.51701287116095323053396202370332611189 Wadena 69.58996060119655625273602801692689333139 Roseau 69.93525762071756137038036147828432694902 Cottonwood 70.03042596348884381338742393509127789047 Lincoln 70.23506988564167725540025412960609911055 Clearwater 70.90522335145355707870479792011344835736 Murray 71.00726895119418483904465212876427829699 Todd 71.18901154461953315918092188421673548496 Marshall 71.75278622087132725430597771023302938197 Rock 73.4304472712351251538777185063602790316 Nobles 74.3372093023255813953488372093023255814 Pipestone 75.58735583084152071764203331909440410081 87 rows selected