SQL Joins: Using the House Votes sqlite file, write SQL queries to answer the following questions:
- Which member has voted no the most often?
- Which member has voted no on Approval of the Journal votes the most often?
- On the votes where one person voted no, who was that person?
Prep Work: Check out Matt Ericson’s Where 2.0 presentation, Using Forms in Google Spreadsheets. I’ll be creating a Google Spreadsheet that I’ll share with all of you. Pick a landmark from your hometown (I use the term “landmark” generously) and add it to the spreadsheet via the form. We’ll use it in class.