Use the tables listed at the end of this document to answer the following questions. Please submit boththe question and the SQL statement for that question. You may simply edit this document byadding...

Use the tables listed at the end of this document to answer the following questions. Please submit boththe question and the SQL statement for that question. You may simply edit this document byadding your answers below each question.There are 15 questions – Questions 1-9 are worth 3 pts; questions 9-14 are worth 4 pts and Question 15is worth 5 points.SQL CommandsAfter each question, construct the SQL statement that answers the question. When specific attributesare 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. 2) What zipcodes are in Georgia? 3) On what date(s) were early votes cast? — No Duplicates 4) List the congressional districts that end in 01 (zero one). 5) What is the age of the oldest candidate running? 6) How many of each type of ballot was cast? 7) List the candidates [by name and position] who are affiliated with the Blue, Red or Orange parties[use the IN keyword]. 8) For each vote, what type of ballot was cast and for what candidate and position? 9) Which candidates, by name and position, are running in either Cobb or Fulton counties? 10) In what county did Sally Brown receive an absentee ballot vote? 11) List the name(s) of the senators who were running in Florida and are from the Blue party? 12) List the names (first and last) and type of ballot cast of all candidates who received votes as well asthe names of candidates who did not receive any votes. 13) List the names of the candidates, the position they are running for, the state in which they arerunning and the date each vote was cast for them. 14) Create a view that lists all Orange party candidates. Change the output column name for CDid toCongressional_District. 15) What was the tally of votes for each presidential candidate? List in order of top vote getter by lastname. Data Tables for ELECTION DATATBASE Notes of Assumptions for this Model (and a little lesson in civics): Only national (federal) offices are shown In regards to Congressional District:o Congressional Districts apply to Congressman [House of Representatives] (ie GA01)o Senators have the CongressionalDistrict of the entire state (ieGAxx)o Presidents have nocongressional district (identifiedby USxx) CDid is short for theCongressionalDistrictIDIn case you are wondering, voterpersonally identifiable information isnot included because it cannot beretain with votes cast (the vote youmake is anonymous). Sample Data:CANDIDATE DISTRICT VOTE