URL: http://node-express-env.y3igtsmx6u.us-east-1.elasticbeanstalk.com/

Tables:

state(`Name`, `White`, `Black`, `Hispanic`, `Asian`, `AmericanIndian`, `PovertyPercent`, `MedianHouseholdIncome`, `HighSchoolGraduatePercent`, `BachelorPercent`, `AdvancedDegrPercent`, `Age1825`, `Age2564`, `Age65`).

Show percentage of each demographic in each state (race, age, education level, income)

turnout_2012_gen(`State`, `PercentTurnout`, `BallotsCounted`, `VotingPopulation`).

turnout_2016_gen(`State`, `PercentTurnout`, `BallotsCounted`, `VotingPopulation`).

polls(`Date`, `State`, `Pollster`, `SampleSize`, `Clinton`, `Trump`)

MySQL Login info
Hostname: election2016.cfkfg0dg7ypb.us-east-1.rds.amazonaws.com
Port: 3306
Username: root
Password: password

Example Queries:

SELECT Date, Clinton, Trump FROM polls WHERE (Date = '10/6/2016' || Date = '10/10/2016') AND State = 'U.S.' GROUP BY Date ORDER BY polls.Date;
SELECT Name FROM state WHERE White>=30 AND White<=40;
SELECT Name FROM state WHERE MedianHouseholdIncome>=60000;

SELECT DISTINCT Date, State, AVG(Clinton), AVG(Trump)  FROM polls
WHERE polls.State="Hawaii"
GROUP BY Date
ORDER BY polls.Date;

SELECT DISTINCT * FROM polls a
WHERE NOT EXISTS
(/*States that do not follow a certain demographic */
SELECT    b.name FROM State b
WHERE b.Black >= 40)

SELECT polls.Date FROM polls, states
WHERE polls.Date LIKE '11/%' AND states.Name NOT IN
(/*states than should not be included*/
SELECT states.name FROM states, polls
WHERE states.name = 'Hawaii' AND states.name <> polls.State
)