Assignments for March 13

Database: Read this tutorial on joins and this description of importing and linking tables in Access.

Database homework: Using this database of Florida primary election results (sound familiar?), write SQL queries to show the following:

  1. The total votes for president by party in 2004 and 2008 (that’s two queries, or it could be one if you were ambitious).
  2. The total number of votes that Dennis Kucinich received in each county for 2004 and 2008 (same as above – could be two queries or one).
  3. The top counties in total votes for Barack Obama in 2008.
  4. The total number of Democratic votes in 2008 for all candidates except Hillary Clinton.
  5. Which counties did John Edwards get at least 100,000 votes in in 2008?

Story for class discussion: Baltimore Sun on speeding. Personal experiences welcomed.


About this entry