Hello, I need help trying to figure out how to do the SQL commands listed in the attachement. I've been stuck on it all day and can't figure it out.

Thank you in advance

 

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.

 

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)        List the candidates [by name and position] who are affiliated with the Blue, Red or Orange parties [use the IN keyword]. 

 

 

2)        In what county did Sally Brown receive an absentee ballot vote?

   

 

 

3)        List the name(s) of the senators who were running in Florida and are from the Blue party? 

 

 

 

4)        List the names (first and last) and type of ballot cast of all candidates who received votes as well as the names of candidates who did not receive any votes.

 

 

 

5)        List the names of the candidates, the position they are running for, the state in which they are running and the date each vote was cast for them. 

           

 

 

6)        Create a view that lists all Orange party candidates.  Change the output column name for CDid to Congressional_District.     

 

 

 

7)        What was the tally of votes for each presidential candidate?  List in order of top vote getter by last name.

 

Use the tables listed at the end of this document to answer the following quesTons.Please submit boththe quesTon and the SQL statement for that quesTon. You may simply edit this document byadding your answers below each quesTon.SQL CommandsAFer each quesTon, construct the SQL statement that answers the quesTon.When speci±c a²ributesare not asked for, you may choose which a²ributes you wish to display.1)List the candidates [by name and posiTon] who are a³liated with the Blue, Red or Orange parTes[use the IN keyword].2)In what county did Sally Brown receive an absentee ballot vote?3)List the name(s) of the senators who were running in ´lorida and are from the Blue party?4)List the names (±rst 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.5)List the names of the candidates, the posiTon they are running for, the state in which they arerunning and the date each vote was cast for them.6)Create a view that lists all Orange party candidates.Change the output column name for CDid toCongressional_District.7)What was the tally of votes for each presidenTal candidate?List in order of top vote ge²er by lastname.IS3280– Test 2 Part b – SQLpage 1 of 2

Attachments:

• 1495414983-is3280TEST2Part2dElection rework.doc