I’ve made so much progress since I last revised my schema in Nov 2017. Most of that progress has been in the last week — two weeks at the very most. The Mobile Web Specialist nanodegree program I’m in as a Google Udacity Scholar via a Grow With Google scholarship has made my skillset and confidence go all supernova.
See also: I have a dream come true (2012 results made manually in Photoshop)
Here is what I’m up to:
This query fetches only socialist candidates (excluding Hillary Clinton in one state where she’s actually on the ballot as a socialist — she’s not included because then she’d win all the states … until I fix my query by, hopefully, finally completing the affiliations table below) to see who among would “win” among the socialist candidates.
Here’s the new schema … I still haven’t added a stateAbbr column to the affiliations2016 table which, I think, is the reason for a problem I’m having with my first major query.
I need some buttons to change what results are fetched and displayed including but not limited to:
- Results if all the “left-ish” third parties voted for a single candidate — would that candidate have beaten Trump?
- If all the right-ish votes went to Trump, would he have have won the popular vote?