completed problem 7 unsuccesfully. obscure error relating to not being able to use c.city.  ask later.  For now I will proceed to rewrite it without a join statement.
Completed question 7