Did everyone do their homework and explore Exercise 2: Joins?
Click here for Exercise 3: a Database with Presidential Election Results at the County Level.
Writing complex SQL queries can be very aggravating because of the lack of constructs in the language that would allow you divide and conquer a problem. This can be partially resolved by using Python to assist in construction of the queries.
Click here for an exercise that calls the SQL queries using Python.