Koen Verbeeck (1/8/2013)
Not sure what this question tries to teach us.
I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I got it right, but I suddenly was surprised the question was about table aliases.
Maybe I was more surprised that apparently the criteria for a query to run succesfully is to get your table aliases correct :-)