More SQL problems (problem 3)

Here is the link to the More SQL problems assignment. This particular deadline is for part 3.