TEST 2 – Part 2: IS3280 Data Management – SQL
Name:______________________________________________________
Use the tables listed at the end of this document to answer the following questions. Please submit both the question and the SQL statement for that question. You may simply edit this document by adding your answers below each question.
Submit via D2L. Name the file yourlastnameExam1Part2 [ie murrayexam2part2.docx].
There are 15 questions – Questions 1-9 are worth 3 pts; questions 9-14 are worth 4 pts and Question 15 is worth 5 points.
SQL Commands
After each question, construct the SQL statement that answers the question. When specific attributes are not asked for, you may choose which attributes you wish to display.
1) What basic information do we have about the candidates? Sort by position.
…show more content…
Select Zipcode from district where district.state= Georgia
3) On what date(s) were early votes cast? -- No Duplicates
Select dateofvote from vote order by DateOfVote desc
4) List the congressional districts that end in 01 (zero one).
Select county, dateofvote from candidate join district on candidate.CDid= district. CDid join vote on candidate.candidateid = vote.candidateid where dateofvote < 01;
5) What is the age of the oldest candidate running? Select lastname, fistname, max(age) as oldestAge from candidate
6) How many of each type of ballot was cast?
Select count(voteID) from vote group by TypeOfBalot
7) List the candidates [by name and position] who are affiliated with the Blue, Red or Orange parties [use the IN keyword].
Select FirstName, lastname Position from candidate where party afficliation IN (Blue,
In the following essay I will be talking about the disadvantages and advantages of partisan elections for state politics. I will also examine the last couple year's election results and costs. Finally, I will discuss if partisanship made a difference in the vote, as well as if a judge should be decided by partisan vote. In the next couple paragraphs I will talk more specifically about these topics.
Each question is worth a maximum of 20 points. Please use the attached grading rubric to help inform your responses.
Texas is one of the most important turfs when it comes to election times in America. This is because the state is dominated by the Republican Party after it produced George W Bush as the president of United States of America. The Republican dominates the election into state offices in the region. Political analysts argue that for a person to be elected in Texas they must run on a republican ticket. A lot of people in the state do not know that Texas was once a stronghold for the Democrats. The Democrats controlled the politics of Texas for more than 100 years until the year 1972 (Newell et.al. 2009). It is important to investigate the history and changes in dominant party in the state because it defined the realm of politics among the people.
Today I will be talking about how the southern borders of California and Florida voting patterns have changed in the past 25 years. In those 25 years there have been significant changes throughout how many people voted Democratic over Republican.
This section deals with California’s history as a party system. If you go all the way back to 1850 when the state of California had its first governor campaign the winner was a man named Peter Burnett a independent democrat raised in Missouri. All of the other positions including Lt. Governor, Attorney General, Secretary of State, and Treasurer were also all independent democrats. The democratic party developed right at the start and thrived fro the next 5 years with a clean sweep. Going into 1856 is when the republican party started to really show their colors in the state of California. Throughout this time the republican party was off and on with holding office chairs but the democratic party I would
A list is a collection of items in which the items have a position (Weiss, 2010). A linked list allows data to be input or removed easily because each of the data items in the list is connected to its neighbor by a pointer
This initiative is designed to focus primarily on state legislative races. The structure and dynamics of these races are much less complicated and therefore offer an ideal starting place for
Each item has one correct answer. Mark your answers to questions 1 to 50 on the computer answer sheet.
The Chi-statistic assess the degree of name order bias and was calculated to give an indication as to the disparity in votes acquired by candidates relating to issues other than party affiliation as: X = (obs-exp)/√exp
from Q. 1 to 9 carries +6 marks for correct answer and –2 marks for wrong answer. Each question
Part one questions carry 1 mark each & Part two questions carry 5 marks each.
Part one questions carry 1 mark each & Part Two questions carry 4 marks each.
Part One questions carry 1 mark each & Part Two questions carry 5 marks each.
Part one questions carry 1 mark each & Part Two questions carry 4 marks each.