title: SQL Questions Regarding Select Statements
body: <p>What percentage of third-party registered voters actually voted? What percentage of non-3rd-party registered voters actually voted?</p>
  
  <pre><code>Select count(*)
  From Vote V, Voter B, Person P
  Where V.Person_ID = B.Person_ID AND B.Register ‘1’ AND (P.Party IN ( ‘Dem’ , ‘Rep’ );
  </code></pre>
  
  <p>This includes the count of how many people that is within the third national party and is registered that voted but I don't understand how would I be able to divide that with the total number of votes. </p>
  
  <pre><code>CREATE TABLE Vote(
    Vote_ID int,
    Person_ID int,            //V.Person_ID, C.Person_ID
    Title varchar(50),
    PRIMARY KEY(Vote_ID)
  );
  
  CREATE TABLE Person(
    Person_ID int,
    First_Name varchar (50),
    Mid_Name varchar(50),
    Last_Name varchar(50),
    Street varchar(45),
    Zipcode int,
    Party varchar(20),
    PRIMARY KEY (Person_ID)
  );
  
  CREATE TABLE Voter(
    Person_ID int,
    Registered int,
    PRIMARY KEY(Person_ID)
  );
  </code></pre>